select p.product_id,p.product_name,
round(sum(p.price*s.quantity),2) as total_sales
from products_underline p left join sales_underline s on p.product_id=s.product_id
where s.sale_month between '2024-01' and '2024-06'
group by p.product_id
order by p.product_id