Monthly Sales Report
MediumUnlock detailed company stats for this questionUpgrade
You are given the following tables:
transactions table:
products table:
users table:
Modify the previous query to report for multiple years. The answer should have the results by month-year. Your output should have the following columns: month_year, num_customers, num_orders, order_amt. Order the result in descending month_year