sosis

SELECT DATE_FORMAT(s.sale_date, '%d-%m') AS sale_date, p.category, CASE WHEN p.name LIKE '%весовая%' THEN 'кг' ELSE 'шт' END AS unit, SUM(sale_amount) AS total_sales
FROM sales s
JOIN products p ON s.product_id = p.product_id
WHERE p.category = 'сосиски' AND MONTH(s.sale_date) = 12
GROUP BY DATE_FORMAT(s.sale_date, '%d-%m'), p.category