Revenue Trend Analysis in SQL Server | Online Course | Vertabelo Academy

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

17/18 Question 2

2. The Northwind database

3. The Employees table

4. The Customers table

5. The Products and Categories tables

6. The Orders and OrderItems tables

7. Revenue to date

8. Revenue to date by group

9. Time constraints in revenue reports

10. The DATEADD() function

11. The DATEADD() function – exercise

12. Calculating the beginning of the current period

13. Month-to-date revenue

14. Month-to-date revenue – exercise

18. Congratulations

Very good! One more question to go.

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

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.