In part 3 of the Aggregate Functions, question 1 asks:
"Count the total number of apps at each price that have been downloaded more than 20,000 times. In the code editor type"
The correct code is:
SELECT price, COUNT(*) FROM fake_apps
WHERE downloads > 20000
GROUP BY price;
My question is why does the query fail if GROUP BY is placed before WHERE clause?