My issue
I am unable to Solve
My code
SELECT
dps.product_type,
dps.product_id,
ms.units_sold,
TO_CHAR(ms.month, 'Mon') AS month
FROM
division_product_sales dps
JOIN
monthly_sales ms
ON
dps.month = ms.month
WHERE
dps.product_margin = 'High_Margin'
AND EXTRACT(YEAR from ms.month) = EXTRACT(YEAR from CURRENT_DATE)
ORDER BY
ms.month, dps.product_type, dps.product_id;
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems