gistfile1.txt

1.
SELECT name,
(price - price * (0.01 * discount)) * quantity AS [revenue]
FROM Product
WHERE name = 'Молоко' OR name = 'Хлеб'
2.
SELECT name, quantity
FROM Product
WHERE quantity > 10
AND date_of_delivery = CAST(GETDATE() as date)
OR date_of_delivery = CAST(GETDATE() -1 as date)
3.
SELECT name, price
FROM Product
WHERE MONTH(date_of_delivery) = MONTH(GETDATE())
4.
SELECT name, price
FROM Product
WHERE category = 'Сладости' AND producer != 'Roshen'
5.
SELECT *
FROM Product
WHERE name LIKE 'К%' 
AND (category LIKE '%А%' OR category LIKE '%а%')
6.
SELECT *
FROM Product
WHERE name LIKE '[В-Л]%'
7.
SELECT *
FROM Product
WHERE price < 50
AND date_of_delivery = CAST(GETDATE() - 7 AS date)
8.
SELECT *
FROM Product
WHERE category = 'Напитки' 
AND quantity > 100
9.
SELECT *
FROM Product
WHERE price BETWEEN 100 AND 200
ORDER BY price ASC
10.
SELECT name,
price*0.95
FROM Product
11.
UPDATE Product
SET date_of_delivery = CAST(GETDATE() AS date)
WHERE date_of_delivery IS NULL
12.
DELETE FROM Product
WHERE price > 70 AND quantity < 100
13.
DELETE FROM Product
WHERE category = 'Алкогольные напитки' OR category = 'Сладости'
14.
SELECT *
FROM Product
WHERE LOWER(name) LIKE '%о%о%о%'
AND LOWER(name) NOT LIKE '%о%о%о%о%'
15.
DELETE FROM Product
WHERE name LIKE '_____'
16.
DELETE FROM Product
WHERE date_of_delivery <= DATEADD(MONTH, -3, GETDATE())
17.
SELECT TOP (5) *
FROM Product
ORDER BY price DESC
18.
DELETE FROM Product
WHERE producer IS NULL OR discount >= 10