can you show me the name and salary of all instructors?
select name, salary from instructor
How much does the biology professor make?
select name, salary from instructor where dept_name = "Biology"
How many professors make more than Valtchev?
select count ( * ) from instructor where salary > ( select salary from instructor where name = "Valtchev" )
Can you tell me the names of the professors that make more than Valtchev?
select name from instructor where salary > ( select salary from instructor where name = "Valtchev" )