gist mana

sasad

ALTER TABLE Products ADD
    Category NVARCHAR(100),
    Brand NVARCHAR(100),
    Discount DECIMAL(5,2),
    DeliveryDate DATE,
    Manufacturer NVARCHAR(100);

------------

SELECT SUM(Price * Quantity * (1 - ISNULL(Discount,0)/100.0)) AS Income
FROM Products
WHERE Name IN ('Хліб','Молоко');

------------

SELECT *
FROM Products
WHERE Quantity > 10
  AND DeliveryDate >= DATEADD(DAY,-1,CAST(GETDATE() AS DATE));
  
  ------------
  
  SELECT Name, Price
FROM Products
WHERE DeliveryDate >= DATEADD(MONTH,-1,GETDATE());
  
  ------------
  
  SELECT Name, Price
FROM Products
WHERE Category = 'Кондитерские выпечки'
  AND Brand <> 'Roshen';
  
  ------------
  
  SELECT *
FROM Products
WHERE Name LIKE N'К%'
  AND Category LIKE N'%А%';
  
  ------------
  
  SELECT *
FROM Products
WHERE Name >= N'В' AND Name < N'М';

------------

SELECT *
FROM Products
WHERE Price < 50
  AND CAST(DeliveryDate AS DATE) = CAST(DATEADD(WEEK,-1,GETDATE()) AS DATE);
  
  ------------
  
  SELECT *
FROM Products
WHERE Category = 'Безалкогольні напої'
  AND Quantity > 100;
  
  ------------
  
  SELECT *
FROM Products
WHERE Price BETWEEN 100 AND 200
ORDER BY Price ASC;

------------

UPDATE Products
SET Price = Price * 0.95;

------------

UPDATE Products
SET DeliveryDate = GETDATE()
WHERE DeliveryDate IS NULL;

------------

DELETE FROM Products
WHERE Quantity < 100 AND Price > 70;

------------

DELETE FROM Products
WHERE Category IN ('Алкогольнфк напитки','Кондитерские выпечкт');

------------

SELECT *
FROM Products
WHERE (LEN(Name) - LEN(REPLACE(LOWER(Name),'о',''))) = 3;

------------

DELETE FROM Products
WHERE LEN(Name) = 5;

------------

DELETE FROM Products
WHERE DeliveryDate < DATEADD(MONTH,-3,GETDATE());

------------

SELECT TOP 5 *
FROM Products
ORDER BY Price DESC;

------------

DELETE FROM Products
WHERE Manufacturer IS NULL
   OR Manufacturer = ''
   OR Discount > 10;

------------