select
    p.product_id product_id,
    p.product_name product_name,
    round(sum(p.price*s.quantity),2) 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,p.product_name
order by
    p.product_id