10.Every or At Least One

Think before you run it: Biology has no instructors. How many rows does this query return?

sql

SELECT name FROM instructor
WHERE salary > ALL (SELECT salary FROM instructor WHERE dept_name = 'Biology');

The instructors who earn more than every instructor in Physics: name, then salary.
The instructors who earn more than at least one instructor in Physics: name, then salary.
The department with the largest budget, found with >= ALL: dept_name.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT name, dept_name, salary FROM instructor;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 40/4 done