My issue
SELECT
dps.product_type,
dps.product_id,
ms.units_sold, – Correctly referencing ms.units_sold
ms.month
FROM
division_product_sales dps
JOIN
monthly_sales ms ON dps.product_id = ms.product_id
WHERE
dps.margin_category = ‘High_Margin’;
this is right query but test cases are not paased ?
My code
SELECT
dps.product_type,
dps.product_id,
ms.units_sold, -- Correctly referencing ms.units_sold
ms.month
FROM
division_product_sales dps
JOIN
monthly_sales ms ON dps.product_id = ms.product_id
WHERE
dps.margin_category = 'High_Margin';
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems