FAQ: Advanced Aggregates - Daily Count 2

This community-built FAQ covers the “Daily Count 2” exercise from the lesson “Advanced Aggregates”.

Paths and Courses
This exercise can be found in the following Codecademy content:

FAQs on the exercise Daily Count 2

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.

Agree with a comment or answer? Like () to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

Is count(1) the same as count(*)?

1 Like

@fjcn97 it seems to accept my code when I use ‘*’ in place of ‘1,’ so yeah I assume they are equivalent here. Anyone else want to weigh in?

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

-T

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

Can someone please assist?

Nevermind:

select date(ordered_at), count(1)
from orders
group by date(ordered_at)