Question

AWS lab 4 write a SQL query for this request: for each month,

retrieve the month and the number of items sold in that month,
sorted by the number of items sold in descending order

Answer 1

To retrieve the month and the number of items sold in that month, sorted by the number of items sold in descending order, you can use the SQL query provided.

Step-by-step explanation:

To retrieve the month and the number of items sold in that month, sorted by the number of items sold in descending order, you can use the SQL query:

SELECT MONTH(date_sold) AS sale_month, COUNT(*) AS num_items
FROM sales_table
GROUP BY sale_month
ORDER BY num_items DESC;

This query uses the MONTH function to extract the month from the date_sold column, then groups the results by month and counts the number of items sold in each month. Finally, the results are sorted in descending order based on the number of items sold.