SELECT
    p.product_id,
    p.product_name,
    SUM(p.price*s.quantity) AS total_sales
FROM
    products_underline AS p
    INNER JOIN
    sales_underline AS s ON p.product_id=s.product_id
WHERE
    s.sale_month BETWEEN '2024-01' AND '2024-06'
GROUP BY
    p.product_id,
    p.product_name
ORDER BY
    p.product_id;