gistfile1.txt

SELECT p.name, c.name
FROM Product p
JOIN Producer pr ON p.id_producer = pr.id
JOIN Category c ON p.id_category = c.id
WHERE pr.name = 'ООО "Паньки"' OR pr.name = 'ООО "Які люди"'


SELECT p.name [Product], pr.name [Producer], c.name [Category]
FROM Product p
JOIN Producer pr ON p.id_producer = pr.id
JOIN Category c ON p.id_category = c.id
WHERE pr.name NOT LIKE N'%а%' AND pr.name NOT LIKE N'%к%' AND pr.name NOT LIKE N'%м%' AND c.name <> 'Крупи'


SELECT p.name, c.name, pr.name, p.price
FROM Delivery d
JOIN Product p ON d.id_product = p.id
JOIN Category c ON p.id_category = c.id
JOIN Supplier s ON d.id_supplier = s.id
JOIN Producer pr ON p.id_producer = pr.id
JOIN Address a ON pr.id_address = a.id
JOIN City ci ON a.id_city = ci.id
JOIN Region r ON ci.id_region = r.id
JOIN Country cn ON r.id_country = cn.id
WHERE cn.name NOT IN ('Україна' , 'Молдова', 'Польща')
	AND d.price < 50 
	AND d.date_of_delivery BETWEEN '2025-02-10' AND '2025-05-12'


SELECT p.name, c.name, s.name, pr.name
FROM  Sale sa
JOIN Product p ON sa.id_product = p.id
JOIN Category c ON p.id_category = c.id
JOIN Delivery d ON d.id_product = p.id
JOIN Supplier s ON d.id_supplier = s.id
JOIN Producer pr ON p.id_producer = pr.id
WHERE c.name IN ('Молочна продукція', 'Хлібобулочні')
GROUP BY p.name, c.name, s.name, pr.name
HAVING SUM(sa.quantity) > 100



SELECT p.name, s.name, c.name, d.date_of_delivery, d.price * d.quantity [Suma]
FROM Delivery d
JOIN Product p ON d.id_product = p.id
JOIN Supplier s ON d.id_supplier = s.id
JOIN Category c ON p.id_category = c.id 
WHERE s.name IN ('Love Water', 'Godfather Company', 'Хлібзавод Курьєр')
ORDER BY p.name ASC