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 D$.$F$\_$NAME, E$.$DEP$\_$NAME FROM EMPLOYEES E$,$ DEPARTMENTS D WHERE DEPT$\_$ID$\_$DEP $=$ 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 F$\_$NAME, DEP$\_$NAME FROM EMPLOYEES E$,$ DEPARTMENTS D WHERE E$.$DEPT$\_$ID$\_$DEP $=$ D$.$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