Question 18
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 all professors who make +7000 more than the lowest-paid professor.
Execute: SELECT Professor, Salary
FROM College
WHERE Salary > (
SELECT MIN(Salary) + 7000
FROM College
);
Answer:
| Professor | Salary |
| John | 60,000 |
| Van der | 57,500 |
| Simrit | 56,500 |
| Jessica | 55,000 |