select

-- comparison
SELECT * FROM Employee
WHERE birthday < GETDATE()

SELECT * FROM Departament
WHERE floorNumber <= 4

SELECT * FROM DesignWork
WHERE startDate >= '2013-01-01'

-- AND, OR, NOT
SELECT * FROM Organization
WHERE city = 'Минск' OR city = 'Киев'

SELECT * FROM Agreement
WHERE price > 5000 AND date < '2022-01-01'

SELECT * FROM Employee
WHERE NOT position = 'Техник' AND NOT position = 'Конструктор'

-- compining logical operators
SELECT * FROM Organization
WHERE address LIKE '%32%' AND NOT typeOfActivity = 'Банк'

SELECT * FROM Employee
WHERE birthday BETWEEN '2001-01-01' AND '2004-01-01' AND NOT position IN('Конструктор')

-- Columns expressions
SELECT * FROM Agreement
WHERE price + agreementId < 800000

SELECT * FROM Agreement
WHERE price/100000 < agreementId

-- Sets
SELECT * FROM Agreement
WHERE price/100000 IN (2,4,8)

SELECT * FROM Employee
WHERE position IN ('Конструктор', 'Техник')

-- Ranges
SELECT * FROM Agreement
WHERE price/100000 BETWEEN 2 AND 8

SELECT * FROM Employee
WHERE position BETWEEN 'Лаборант' AND 'Техник'

-- Pattern
SELECT * FROM Employee
WHERE address LIKE '%53%'

SELECT * FROM Employee
WHERE name LIKE 'С%'

-- not null
SELECT * FROM Employee
WHERE departamentId IS NULL

SELECT * FROM Employee
WHERE departamentId IS NOT NULL