with zw as ( select p.product_id, p.product_name, p.category, date_format(o.order_date,'%Y-%m') as date, ifnull(o.total_amount,0.00) as total_amount from product_info p left join order_info o on p.product_id = o.product_id and date_format(o.order_date,'%Y-%m') in ('2024-04','2024-05','2024-06') ) se...
