select product_id,product_name,sum(quantity) as total_sales,max(quantity) as max_monthly_sales,min(quantity) as min_monthly_sales,round(avg(quantity),0) as avg_monthly_sales
from products_underline p join sales_underline s using(product_id)
where sale_month between '2024-01' and '2024-06'
group by product_id,product_name