( SINGLE TABLE QUERIES)

1.Find all information on employees

2.Find the first and last names of employees

3.Find unique titles in the employee database

4.Find the employee number, start date and monthly salary of each employee

5.Find the employee number of all employees who make between $60000 and $71000 (both inclusive)

6.Find all information about employees whose last name or first name is Demeyer

7.Find employee numbers, start and end date of all employees who are Senior Engineers, Assistant Engineers, Engineers, or Technique Leaders

Use the IN statement

8.Find employee numbers, start and end date of all employees whose name is not Facello, Zielinski, Haddadi, Berztiss or Demeyer

(PATTERN MATCHING)

Find all employees who have the letters lin in their last name

Find salaries of employees by ascending order, and descending order of start date