select
    product_id,
    product_name,
    round(sum(quantity * price), 2) as total_sales
from
    sales_underline
    join products_underline using (product_id)
where
    sale_month between '2024-01' and '2024-06'
group by
    product_id,
    product_name
order by
    product_id asc;