/* ------------------------------------------------------------------------ */
/* Write and test the following queries ----------------------------------- */
/* ------------------------------------------------------------------------ */

/* 1. Print all jobs. */
SELECT DISTINCT job
FROM emp;

/* 2. Print names and hiring dates of all clerks. */

/* 3. List names and jobs of all employees. */
  
/* 4. List names and jobs of employees with salary at least 2000. */

/* 5. Print names and salaries of all managers and analysts (in a single SELECT query). */

/* 6. Print the id of the department in which the president works. (Your query must not use a specific emp_id.) */

/* 7. Print names of employees who were hired between 1981 and 2000. */

/* 8. Print names and salaries of all managers and analysts. */

/* 9. Print all employees that have names beginning with the letter M and salary between 1000 and 2000. */

/* 10. Print the name of the department in which the president works. */