1. Use CTE ( WITH...AS...) to rewrite the query of #2 (list the name and job title of the faculties who received the salary raise.

2. List the name of the department that have less than 2 people. (Hint: aggregation and having)

3. List the total, average, max, and min salaries of all faculties, and rename the column names as total_salary, average_salary, highest_salary, lowest_salary. (Hint: aggregation and rename column)

4.The salary tiers are defined as: Tier1: <=80000 Tier2: >80000 and <=95000 Tier3: >95000