My issue
unable to solve test cases
My code
SELECT
d.product_type,
d.product_id,
d.units_sold,
m.month
FROM
division_product_sales d
JOIN
monthly_sales m ON m.month = d.month
WHERE
d.product_type IN ('Jeans', 'Tshirt', 'Trousers', 'Innerwear') -- assuming these are high-margin categories
AND
m.type_of_product = 'High_Margin'
ORDER BY
d.month, d.product_type;
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems