For Question 1, you need to get the total sales by product f…
For Question 1, you need to get the total sales by product for a specific year, sorted in descending order of total sales. If you’re not confident in how to approach this, follow the directions below, otherwise jump to the question in the last line: 1. Look at the data in the orders, items and products table. Note that there are columns for units sold and price per unit. To get the sales, you need to multiply the units sold and price per unit. You are also asked to filter for 2024. Look closely and identify the date column that you can use for filtering by year. These columns are spread across multiple table. So, figure out which tables you need to join together and which columns you need, to join these tables. 2. Write a query to join the tables using the appropriate join columns ( you can use inner joins) and output the SUM of units sold *price per unit. If you did this correct, without any filtering, you will get the number 3704843.40 3. Filter the results in the above query for the year 2024 using the appropriate clause. 4. To get the total sales by product name, you need to aggregate the sales by the appropriate column. Modify the above query using the appropriate GROUP BY column and output that group by column, along with the sum of price per unit * units sold. Use the alias ‘total_sales’ for the aggregated column. 5. Sort the output by descending order of the total sales. The output will look similar to this (Values are fake though) : Question: Write a query to get the total sales by product names for the year 2024 in descending order of total sales. What is the product with the highest sales and what is the total sales amount for that product for that year?
Read Details