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)
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!