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


#1

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!


#2

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'.