My issue
I am not able to solve this query can you help me with this query if possible provide solution!!
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 dps.product_type, dps.product_id, dps.units_sold,ms.month
from division_product_sales as dps
join monthly_sales as ms on dps.month=ms.month
join product_catalog as pc on dps.product_id = pc.product_id
where pc.margin_type = 'High_Margin';
Learning course: Database management systems
Problem Link: Project - JOIN and Filtering in Database management systems