28.04

gistfile1.txt

1.

UPDATE Products_menu
SET date_of_delivery = GETDATE()
WHERE date_of_delivery = NULL

2.

DELETE FROM Products_menu
WHERE measurement < 100 AND price > 70

3.

DELETE FROM Products_menu
WHERE category LIKE 'Кондитерские%' AND category LIKE 'Алкогольные%'

4.

DELETE FROM Products_menu
WHERE name LIKE '_____'

5.

DELETE FROM Products_menu
WHERE date_of_delivery < DATEADD(MONTH, -3, GETDATE());

6.

DELETE FROM Products_menu
WHERE producer = NULL AND discount > 10