Task: SQLite Count, Group, and Order by Count
Task: SQLite Count, Group, and Order by Count: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL query against a SQLite database that counts the occurrences of each unique value in the BAR column, groups the results, and orders them by count in descending order.
The task
Write a SQL query against a SQLite database that counts the occurrences of each unique value in the `BAR` column, groups the results, and orders them by count in descending order.
Part of PrimeIntellect/Terminal-Lego-15k.