1

USE ATB
SELECT name,(price - (price * discount) / 100) * quantity AS [Можливий заробіток]
From Product
WHERE (name LIKE 'Хліб%' OR name = 'Молоко')

10

USE ATB

UPDATE Product
SET price = ROUND(price * 0.95, 2)

SELECT *
From Product

11

USE ATB

UPDATE Product
SET date_of_delivery = GETDATE()
WHERE date_of_delivery IS NULL

SELECT *
From Product

12

DELETE FROM Product WHERE quantity < 100 AND price > 70;

SELECT *
FROM Product

13

DELETE FROM Product WHERE category = 'Фрукти' AND category = 'М’ясні продукти';

SELECT *
FROM Product

15

SELECT *
FROM Product

DELETE FROM Product
WHERE LEN(name) = 5

16

SELECT *
FROM Product

DELETE FROM Product
WHERE date_of_delivery > DATEADD(MONTH, -3, '2025-06-03')

17

SELECT TOP 5 *
FROM Product

ORDER BY price DESC

18

DELETE FROM Product WHERE producer IS NULL OR discount > 10;

SELECT *
FROM Product

2

USE ATB
SELECT name, date_of_delivery, quantity
From Product
--WHERE (name LIKE 'Хліб%' OR name = 'Молоко')

WHERE quantity > 10 AND date_of_delivery = DATEADD(DAY, -1, '2025-06-03')

3

USE ATB
SELECT name, date_of_delivery, price
From Product
WHERE date_of_delivery > DATEADD(DAY, -30, '2025-06-03')

5

USE ATB
SELECT *
From Product
WHERE name LIKE 'К%' AND category LIKE '%а%'

6

USE ATB
SELECT *
From Product
WHERE name LIKE '[В-Л]%'

7

USE ATB
SELECT name, date_of_delivery, price
From Product
WHERE date_of_delivery = DATEADD(WEEK, -1, '2025-06-03')
AND price < 50

8

USE ATB
SELECT category, quantity
From Product
WHERE category = 'Овочі' AND quantity > 25 --P.S категорії "безалкогольні напої немає"

9

USE ATB
SELECT *
From Product
WHERE price >= 100 AND price <= 200
ORDER BY price