There are currently no frequently asked questions associated with this exercise – that’s where you come in! You can contribute to this section by offering your own questions, answers, or clarifications on this exercise. Ask or answer a question by clicking reply () below.
If you’ve had an “aha” moment about the concepts, formatting, syntax, or anything else with this exercise, consider sharing those insights! Teaching others and answering their questions is one of the best ways to learn and stay sharp.
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply () below!
Agree with a comment or answer? Like () to up-vote the contribution!
Bit late but I found this explanations on stackoverflow (note that these are not from SQLite):
They seem to return the same results, however most of the discussion as to the difference is in how SQL handles the query and how this impacts performance (could be legacy stuff as well as the language is around for decades): COUNT(0/1/‘whatever’) retrieves 0/1/‘whatever’ per record and then counts those, which does essentially the same as COUNT(*) does.
Bottom line seems to prefer COUNT(*) unless you’re explicitly excluding NULL values from row counts, i.e. COUNT(column_name).
When you click ‘Get Unstuck’, there is nothing under the ‘Get Code Solution’ beyond the initial two check points. So, there is no solution for Daily Count 2’s question.
When I type the suggested code, it returns the error, ‘Group and count the orders by their dates’:
select date(ordered_at)
from orders
group by date(ordered_at)
order by date(ordered_at);
) below.
) to up-vote the contribution!