1) List the name, job and income for the workers who work in Dallas or Chicago.

2) List the name of the workers, their salary, the name of their boss, the boss' departments' location and the sum salary of that place.

3) List the number of employees for each boss, along with their departments, average income, and the difference between that average and the boss' income.

... do we need the department of the boss (A), or the workers (B)???

4) List the jobs according to the departments, and the number of workers, the minimum and maximum salaries according to that job. Order the list by the department (ascending) and job (descending).

... "that job" = ???

5) (3.29)
List the name, job, department name and salary for every worker.
Add the percentage of this salary compared to the average salary of his job.
Add the percentage of this salary compared to the average salary of his department.

Solve the exercise using views AND separately using CTEs

6) Display every worker's name, their department's name, their boss' name. The list should include the income parameter for both the boss and the worker.
Income parameter: (income) - (the average income of those who entered the company the same year)