My issue
Help me with this code its showing error:Status :Runtime error
Runtime Error
SIGHUP
Error
Parse error near line 97: near “FROM”: syntax error
gin_category = ‘High_Margin’ AND EXTRACT(YEAR FROM ms.month) = EXTRACT(YEA
error here —^
My code
SELECT
p.product_type,
p.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
JOIN
products p ON dps.product_id = p.product_id
WHERE
dps.margin_category = 'High_Margin'
AND EXTRACT(YEAR FROM ms.month) = EXTRACT(YEAR FROM CURRENT_DATE);
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems