---

SELECT * FROM Employees;

SELECT first_name, last_name
FROM Employees;

SELECT Name
FROM Employees
WHERE Age > 28;

SELECT *
FROM Employees
WHERE Name = 'Bob Smith';

SELECT Name, Salary
FROM Employees
WHERE IsActive = TRUE;

SELECT Name
FROM Employees
WHERE Salary > 50000 AND IsActive = TRUE;

SELECT name, age
FROM students
WHERE faculty = 'Computer Science'
  AND city = 'Moscow'
  AND age >= 18;


SELECT title, pages
FROM books
WHERE (author = 'Tolstoy' OR year > 2010) AND pages <= 300;



SELECT name, age, faculty, scholarship
FROM students
WHERE scholarship = 0
  AND (faculty = 'Mathematics' OR faculty = 'Physics' OR age > 22);



SELECT *
FROM Books
WHERE rating <> 5
  AND (
      (year_published < 2000 OR rating > 8)
  OR 
      (year_published > 2010 AND pages < 300 AND rating >= 7)
      );