dz.sql

 SELECT 
        s.id AS SaleID,
        p.name AS ProductName,
        c.name AS CategoryName,
        s.quantity,
        s.price,
        s.date_of_sale
    FROM Sale s
    INNER JOIN Product p ON s.id_product = p.id
    INNER JOIN Category c ON p.id_category = c.id
    WHERE c.name LIKE N'%Молочні продукти%';

     SELECT 
        p.name AS ProductName,
        SUM(s.quantity) AS TotalQuantitySold
    FROM Sale s
    INNER JOIN Product p ON s.id_product = p.id
    INNER JOIN Category c ON p.id_category = c.id
    WHERE c.name LIKE N'%Хлібобулочні вироби%'
      AND s.date_of_sale >= DATEADD(MONTH, -3, GETDATE())
    GROUP BY p.name
    ORDER BY TotalQuantitySold DESC;

     SELECT 
        c.name AS CategoryName,
        YEAR(s.date_of_sale) AS SaleYear,
        MONTH(s.date_of_sale) AS SaleMonth,
        SUM(s.quantity) AS TotalQuantity,
        SUM(s.quantity * s.price) AS TotalRevenue
    FROM Sale s
    INNER JOIN Product p ON s.id_product = p.id
    INNER JOIN Category c ON p.id_category = c.id
    WHERE (c.name LIKE N'%Молочні продукти%' OR c.name LIKE N'%Мясо%')
      AND s.date_of_sale >= DATEADD(YEAR, -1, GETDATE())
    GROUP BY c.name, YEAR(s.date_of_sale), MONTH(s.date_of_sale);

    SELECT 
        p.name AS ProductName,
        c.name AS CategoryName
    FROM Product p
    INNER JOIN Category c ON p.id_category = c.id
    WHERE c.name LIKE N'%Мясо%'
      AND NOT EXISTS (
          SELECT 1
          FROM Sale s
          WHERE s.id_product = p.id
            AND s.date_of_sale >= DATEADD(DAY, -90, GETDATE()))