with
t1 as(
    select
        product_id,
        product_name,
        sum(price*quantity) as total_sales
    from
        sales_underline left 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
)

select * from t1