Question 7
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 name and salary of the professor of the computer science department with the highest salary.
Execute: Sol1: SELECT Professor, Salary
FROM College WHERE Department = 'Computer Science'
ORDER BY Salary DESC
LIMIT 1;
FROM College WHERE Department = 'Computer Science'
ORDER BY Salary DESC
LIMIT 1;
Sol 2: SELECT Professor, MAX(Salary)
FROM College WHERE Department = 'Computer Science';
FROM College WHERE Department = 'Computer Science';
Answer:
Professor | Salary |
John | 60,000 |