Skip to content

Instantly share code, notes, and snippets.

@DO162

DO162/product.sql

Created January 27, 2026 13:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save DO162/bced552c864d77b0535c00c799625048 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save DO162/bced552c864d77b0535c00c799625048 to your computer and use it in GitHub Desktop.
Download ZIP
DZ_3_(18.12.25)_SQL
Raw
product.sql
SELECT
SUM(price * quantity * (1 - discount / 100.0)) AS possible_income
FROM product
WHERE name LIKE '%Хліб%'
OR name LIKE '%Молоко%';
SELECT *
FROM product
WHERE quantity > 10
AND date_of_delivery >= DATEADD(day, -1, CAST(GETDATE() AS date));
SELECT name, price
FROM product
WHERE date_of_delivery >= DATEADD(month, -1, GETDATE());
SELECT name, price
FROM product
WHERE category = 'Кондитерські вироби'
AND producer <> 'Roshen';
SELECT *
FROM product
WHERE name LIKE 'К%'
AND category LIKE '%А%';
SELECT *
FROM Product
WHERE name >= 'В'
AND name < 'М';
SELECT *
FROM product
WHERE price < 50
AND date_of_delivery = CAST(DATEADD(day, -7, GETDATE()) AS date);
SELECT *
FROM Product
WHERE category = 'Безалкогольні напої'
AND quantity > 100;
SELECT *
FROM product
WHERE price BETWEEN 100 AND 200
ORDER BY price ASC;
UPDATE product
SET price = price * 0.95;
UPDATE product
SET date_of_delivery = CAST(GETDATE() AS date)
WHERE date_of_delivery IS NULL;
DELETE FROM product
WHERE quantity < 100
AND price > 70;
DELETE FROM product
WHERE category IN ('Алкогольні напої', 'Кондитерські вироби');
SELECT *
FROM product
WHERE LEN(name) - LEN(REPLACE(UPPER(name), 'О', '')) = 3;
DELETE FROM product
WHERE LEN(name) = 5;
DELETE FROM product
WHERE date_of_delivery < DATEADD(month, -3, GETDATE());
SELECT TOP 5 *
FROM product
ORDER BY price DESC;
DELETE FROM product
WHERE producer IS NULL
OR discount > 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment