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

$1$ point

SELECT LOWEST$($SALARY$)$ FROM EMPLOYER

SELECT MIN$($SALARY$)$ FROM EMPLOYEES

SELECT MAX$($SALARY$)$ FROM EMPLOYEES

SELECT SALARY FROM EMPLOYEES WHERE MINIMUM$($SALARY$)=$ SALARY

$2.$

Question $2$

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

$1$ point

SELECT MAX$($SALARY$)$ FROM EMPLOYEES

SELECT FIRST$\_$NAME, MAX$($SALARY$)$ FROM EMPLOYEES GROUP BY F$\_$NAME

SELECT FIRST$\_$NAME FROM EMPLOYEES WHERE SALARY $=$

$($ SELECT MAX$($SALARY$)$ FROM EMPLOYEES $)$

SELECT FIRST$\_$NAME FROM EMPLOYEES WHERE SALARY IS HIGHEST

$3.$

Question $3$

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

$1$ point

SELECT $*$ FROM EMPLOYEES WHERE DEP$\_$ID $=$ MAX$($DEP$\_$ID$)$

SELECT $*$ FROM EMPLOYEES WHERE DEP$\_$ID $=$

$($ SELECT DEPT$\_$ID$\_$DEP FROM DEPARTMENTS WHERE DEPT$\_$ID$\_$DEP IS MAX $)$

SELECT $*$ FROM EMPLOYEES WHERE DEP$\_$ID $=$

$($ SELECT MAX$($DEPT$\_$ID$\_$DEP$)$ FROM DEPARTMENTS $)$

SELECT $*$ FROM EMPLOYEES WHERE DEPT$\_$ID$\_$DEP $=$

MAX $($ SELECT DEPT$\_$ID$\_$DEP FROM DEPARTMENTS $)$

$4.$

Question $4$

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?

$1$ point

SELECT F$\_$NAME, DEP$\_$NAME FROM EMPLOYEES E$,$ DEPARTMENTS D WHERE E$.$DEPT$\_$ID$\_$DEP $=$ D$.$DEP$\_$ID

SELECT F$\_$NAME, DEP$\_$NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT$\_$ID$\_$DEP $=$ DEP$\_$ID

SELECT E$.$F$\_$NAME, D$.$DEP$\_$NAME FROM EMPLOYEES, DEPARTMENTS

SELECT D$.$F$\_$NAME, E$.$DEP$\_$NAME FROM EMPLOYEES E$,$ DEPARTMENTS D WHERE DEPT$\_$ID$\_$DEP $=$ DEP$\_$ID

$5.$

Question $5$

You are writing a query that will give you the total cost to the Pet Rescue organization of rescuing animals. The cost of each rescue is stored in the Cost column. You want the result column to be called $$Total$\_$Cost$.$ Which of the following SQL queries is correct?

$1$ point

SELECT SUM$($Cost$)$ FROM PetRescue

SELECT SUM$($Cost$)$ AS Total$\_$Cost FROM PetRescue

SELECT SUM$($Total$\_$Cost$)$ From PetRescue

SELECT Total$\_$Cost FROM PetRescue