You have a products table and a sales table with product_id, sale_date, and quantity. Write a query that returns products that had zero sales in the most recent month but had sales in the prior month.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

You have a products table and a sales table with product_id, sale_date, and quantity. Write a query that returns products that had zero sales in the most recent month but had sales in the prior month.

Practice more