Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started