gistfile1.txt

SELECT p.name [Product],
	   pr.name [Producer]
FROM Product p RIGHT OUTER JOIN Producer pr ON p.id_category = pr.id


SELECT c.name[Categories],
	   p. name [Product]
FROM Product P RIGHT OUTER JOIN Category c ON p.name = NULL


SELECT p.name [Product],
	s. name [Suppliers],
	d.date_of_delivery [Date of delivery]
FROM Supplier s
LEFT OUTER JOIN Delivery d ON s. id = d.id_supplier
LEFT OUTER JOIN Product p ON d.id_product = p.id


SELECT r.name [Region]
FROM Region r
EXCEPT
SELECT r.name
FROM Producer p
JOIN Address a ON p.id_address = a.id
JOIN City c ON a.id_city = c.id
JOIN Region r ON c.id_region = r.id


SELECT c.name [Category]
FROM Category c
EXCEPT
SELECT s.name
FROM Supplier s
JOIN Supplier ss ON s.name != 'ООО "Нли Ю"'


SELECT p.name [Producer]
FROM Producer p
EXCEPT
SELECT p.name
FROM Product p
JOIN Category c ON p.id_category = c.id
JOIN Producer pr ON p.id_producer = pr.id
WHERE p.id_category = 1