One request for this project is:
Next filter the result to only include categories that have more than three companies in them.
What are the most competitive markets?
My code is the following but the terminal returns nothing:
SELECT category, COUNT(*) FROM startups GROUP BY category HAVING 2 > 3;
The hint gives and it works:
SELECT category, COUNT(*) FROM startups GROUP BY category HAVING COUNT(*) > 3;
My question is: why cannot HAVING 2 (referring to the second selected column COUNT(*) in this case) work? Thanks!