Sales Report
MediumUnlock detailed company stats for this questionUpgrade
You are given the following tables:
transactions table:
products table:
users table:
Write a query to report the number of users, number of transactions placed and total order amount per month in the year 2020. Your output should have the following columns: month_name, num_customers, num_orders, order_amt. Order the result in descending month.