My issue
please help me
SELECT
dp.product_type,
dp.product_id,
ms.units_sold, – Assuming ‘units_sold’ is the correct column in ‘monthly_sales’
ms.month
FROM
division_product_sales dp
JOIN
monthly_sales ms
ON dp.product_id = ms.product_id
WHERE
dp.product_type = ‘High_Margin’;
this code gives me error
My code
/* Write a query to output the following
- product_type, product_id, units_sold and month of sale for all high margin products sold in the year */
SELECT
dp.product_type,
dp.product_id,
units_sold, -- Assuming 'units_sold' is the correct column in 'monthly_sales'
monthly_sales.month
FROM
division_product_sales dp
JOIN
monthly_sales
ON dp.product_id = dp.product_id
WHERE
dp.product_type = 'High_Margin';
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems