SQL Database

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: