select p.product_id,product_name,sum(quantity) total_sales,max(quantity) max_monthly_sales,
min(quantity) min_monthly_sales,round(avg(quantity),0) avg_monthly_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