Skip to main content

Practice ยท 2 of 3

GROUP BY Simulator

Write groupByCount(rows, key) returning an array of { key: keyValue, count } sorted by count desc (ties: key asc). Write having(rows, key, min) chaining: group, then keep groups with count >= min.

Difficulty: intermediate

Back to lesson: Practice: SQL Mechanics โ€” Practice