SQL: Analyzing Business Metrics: Daily Count2, Stuck on 3/12


I'm stuck as to what I'm selecting to type in the correct query. I tried entering different variations of
select date(ordered_at), count(1)
from orders
group by 1
order by 1;

What am I typing wrong since I keep getting a syntax error or the error message telling me I need to group and count the orders by the date. Thanks!


Pretty sure the syntax error is because your second query is not specifying what it's looking for in orders. It's essentially saying:

Look for 'nothing' in 'orders' then group and order 'nothing' by 'nothing'.