#查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额。
select a.product_id,product_name,round(sum(price*quantity),2) as total_sales
from sales_underline as a
inner join products_underline as b
on a.product_id = b.product_id
where sale_month between '2024-01' and '2024-06'
group by a.product_id,product_name