QueryHW

-- Task 1
SELECT name, price, discount, quantity , quantity * (price * (1- discount)) AS total
FROM Product
WHERE name LIKE '%bread%' OR name LIKE 'milk'

-- Task 2
SELECT name, quantity
FROM Product
WHERE date_of_delivery BETWEEN DATEADD(day, -2, GETDATE()) AND GETDATE() AND quantity > 100

-- Task 3
SELECT name, price
FROM Product
WHERE MONTH(date_of_delivery) >= MONTH(GETDATE())

-- Task 4
SELECT name, price 
FROM Product
WHERE category LIKE '%Snacks%' AND supplier <> '%NutriCo%'

-- Task 5
SELECT name
FROM Product
WHERE name LIKE 'C%' AND category LIKE '%A%'

-- Task 6
SELECT name
FROM Product
WHERE name BETWEEN 'A' AND 'H'
ORDER BY name;

-- Task 7
SELECT name 
FROM Product
WHERE date_of_delivery BETWEEN '2023-10-01' AND GETDATE() - 1 AND price < 5

-- Task 8
SELECT name, quantity
FROM Product
WHERE category LIKE '%Beverage%' AND quantity > 100

-- Task 9
SELECT name, price 
FROM Product
WHERE price BETWEEN 10 AND 20
ORDER BY PRICE DESC

-- Task 10
UPDATE Product
SET price = price * 0.95

-- Task 11
UPDATE Product
SET date_of_delivery = GETDATE()
WHERE date_of_delivery = NULL

-- Task 12
DELETE FROM Product 
WHERE quantity < 100 AND price > 70

-- Task 13
DELETE FROM Product 
WHERE category LIKE '%Sweeteners%'

-- Task 14
SELECT name
FROM Product
WHERE LEN(name) - LEN(REPLACE(name, 'o', '')) = 3;

-- Task 15
DELETE FROM Product 
WHERE LEN(name) = 5

-- Task 16
DELETE FROM Product
WHERE date_of_delivery < DATEADD(MONTH, -3, GETDATE())

-- Task 17
SELECT TOP 5 name, price
FROM Product
ORDER BY price DESC

-- Task 18
DELETE FROM Product
WHERE producer = NULL OR discount > 10