FAQ: Advanced Aggregates - Daily Revenue

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

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

SQL: Analyzing Business Metrics

FAQs on the exercise Daily Revenue

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 (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 (reply) below!

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

Need broader help or resources? Head here.

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

Learn more about how to use this guide.

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!

So this exercise is trying to get us to join the two tables, right? If we are selecting 2 columns, each from a different table, don’t you have to specify which table each column comes from with table_name.column_name?

Then the exercise refused to accept the columns in the above syntax and accepted this:

select date(ordered_at), round(sum(amount_paid), 2)
from orders
join order_items
on orders.id = order_items.id
group by 1
order by 1;

Did I get mixed up with another language somewhere?

the tables for the columns are being specified
On orders.id = order_items.id

orders.id is the id column from the orders table and
order_items.id is the id column from the order_items table

Hi ,

Why are these two queries giving different results ? I used the first one and the second one is solution given by Codecademy.

thanks!!

– DAILY REVENUE

Select date(ordered_at) , ROUND ( SUM(amount_paid) , 2) AS ‘DAILY REVENUE’
From order_items
Join orders on order_items.id = orders.id
group by 1
order by 1
Limit 10 ;

select date(ordered_at), ROUND(SUM(amount_paid), 2)
from orders
JOIN order_items on
orders.id = order_items.order_id
group by 1
order by 1
Limit 10 ;

I was only able to progress when I entered:

select date(ordered_at), ROUND(SUM(amount_paid), 2)
from orders
JOIN order_items on
orders.id = order_items.order_id
group by 1
order by 1