select pu.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 pu join sales_underline su on pu.product_id = su.product_id where sale_month < '2024-07' an...
