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