SQL Revenue Trend Analysis | Online Course

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

18/19 Question 2

1. Welcome

2. The Northwind database

3. The employees table

4. The customers table

5. The products and categories tables

6. The orders and order_items tables

7. Revenue to date

8. Revenue to date by group

9. Time constraints in revenue reports

10. How to add interval to date

11. How to add interval to date – exercise

12. Calculating the beginning of the current period

13. Calculating the beginning of the current period – a practical approach

14. Month-to-date revenue

15. Month-to-date revenue – exercise

Very good! One more question to go.

For each shipping country, find the month-to-date revenue. Show two columns: ship_country and total_revenue.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Revenue Trend Analysis in SQL

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?