Which of the following will retrieve the LOWEST value of SALARY in a table called EMPLOYEES?

Assume there exists an INSTRUCTOR table with several columns including FIRSTNAME, LASTNAME, etc. Which of the following is the most likely result set for the following query:

SELECT DISTINCT(FIRSTNAME) FROM INSTRUCTOR

Which of the following queries will return the first name of the employee who earns the highest salary?

Which of the following queries will return the data for employees who belong to the department with the highest value of department ID.

A DEPARTMENTS table contains DEP_NAME, and DEPT_ID_DEP columns and an EMPLOYEES table contains columns called F_NAME and DEP_ID. We want to retrieve the Department Name for each Employee. Which of the following queries will correctly accomplish this?