1. List the department name and the number of faculties in each department. (Hint: aggregation function and group by)

2. List the name and job title of the faculties who received the salary raise. (Hint: table join FACULTY, JOB_TITLE and SALARY_RAISE)

3. List the name of the top 2 faculties who make the most salary. (Hint: Order by and Limit)

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

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

6.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)

7.The salary tiers are defined as:

Tier1: <=80000

Tier2: >80000 and <=95000

Tier3: >95000

List the name, salary, and salary tier for all faculties. (Hint: CASE statement)