Question 4

Table Name: College

Relevant Table: College(Professor (Text), Department (text), Salary (INT))

Professor Department  Salary
John Computer Science 60,000
Van der Mechanical Engineering 57,500
Ackerman Physics 45,000
Suyash Mathematics 52,000
Simrit Computer Science 56,500
Jessica Computer Science 55,000
Jenny Personality Development 50,000

QUERY: Write a Query that returns the number of Professors whose Salary is greater than 54,000.

Execute: SELECT COUNT(Professor) FROM College WHERE Salary > 54000;

Answer:

COUNT(Professor) : 4

This query returns the table:

SELECT Professor, Department, Salary FROM College WHERE Salary > 54000;

Professor Department  Salary
John Computer Science 60,000
Van der Mechanical Engineering 57,500
Simrit Computer Science 56,500
Jessica Computer Science 55,000