EX-01:
Write a T-SQL statement that returns the faculty ID, last name and salary of the faculty members with a doctorate and who have one of the top three salary values. Make sure that faculty with the same salaries as one of the top 3 are included.
SOLUTION:
EX-02:
Write a T-SQL statement that returns the faculty ID, last name and monthly salary of two faculty members with the two lowest monthly salary values.
SOLUTION:
EX-03:
Create a T-SQL script that returns the student ID, last name and GPA of each student with a GPA in the top 10% of students. Make sure that only actual GPA values are used to determine the top 10%.
SOLUTION:
EX-04:
Create a T-SQL script that returns the student ID, last name and GPA of each student with a GPA in the top 0.5% of the students. Make sure that all students with a GPA that matches one of those in the top 0.5% are included.
SOLUTION: