Graded Quiz: Functions, Sub-Queries, Multiple Tables

Graded Quiz: Functions, Sub-Queries, Multiple Tables >> Databases and SQL for Data Science with Python

SELECT * FROM EMPLOYEES WHERE DEP_ID =

( SELECT DEPT_ID_DEP FROM DEPARTMENTS WHERE DEPT_ID_DEP IS MAX )

SELECT * FROM EMPLOYEES WHERE DEPT_ID_DEP =

MAX ( SELECT DEPT_ID_DEP FROM DEPARTMENTS )

SELECT * FROM EMPLOYEES WHERE DEP_ID = MAX(DEP_ID)

SELECT * FROM EMPLOYEES WHERE DEP_ID =

( SELECT MAX(DEPT_ID_DEP) FROM DEPARTMENTS ) ✓

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

SELECT F_NAME, DEP_NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT_ID_DEP = DEP_ID ✓

SELECT F_NAME, DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE E.DEPT_ID_DEP = D.DEP_ID

SELECT SUM(Cost) FROM PetRescue

SELECT SUM(Cost) AS Total_Cost FROM PetRescue ✓

SELECT SUM(Total_Cost) From PetRescue

SELECT Total_Cost FROM PetRescue

Graded Quiz: Functions, Sub-Queries, Multiple Tables >> Databases and SQL for Data Science with Python