My issue
Solve this issue
My code
/* Write a query to output the following
- product_id, units_sold and month of sale for all high margin products sold in the year */
SELECT
dp.product_id,
ms.units_sold,
ms.month
FROM
division_product_sales dp
JOIN
monthly_sales ms
ON
dp.month = ms.month
WHERE
dp.margin_category = 'High_Margin'
AND dp.year = YEAR(CURDATE());
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems