Question 8Which query will select all columns from the customer table and alias the table to cust?1 pointSELECT *FROM customer AS custSELECT *FROM customer TO custSELECT *FROM customer NEW custSELECT *FROM customer ALIAS cust

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 pointSELECT D.F_NAME, E.DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE DEPT_ID_DEP = DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE E.DEPT_ID_DEP = D.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT_ID_DEP = DEP_IDSELECT E.F_NAME, D.DEP_NAME FROM EMPLOYEES, DEPARTMENTS

With SQL, how do you select all the columns from a table named "Persons"?Select one:a.SELECT Personsb.SELECT [all] FROM Personsc.SELECT *.Personsd.None of the answers are correcte.SELECT * FROM Persons

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;Question 39Select one:a.Equi-joinb.Natural joinc.Outer Joind.Cartesian Join

Question 4What will this query return?SELECT *FROM Books_tableLEFT JOIN Biography_table1 pointAll records in Books_table and any matching rows from Biography_tableAll records in both Books_table and Biography_tableAll records in Biography_table and any matching rows from Books_tableAll rows from Books_table joined together with Biography_table

Question 5When querying a table called Teachers that contains a list of teachers and the city they teach in, which of the following queries will return the number of teachers from each city?1 pointSELECT distinct(City) FROM Teachers SELECT City, count(City) FROM TeachersSELECT City, count(City) FROM Teachers GROUP BY CitySELECT City, distinct(City) FROM Teachers GROUP BY City6.Question 6You want to retrieve a list of employees by first name and last name for a company that are between the ages of 30 and 50. Which clause would you add to the following SQL statement: SELECTFirst_Name,Last_Name, Age FROM Company1 pointWHERE Age > 30IF Age >=30 AND Age <=50WHERE Age < 30WHERE Age >=30 AND Age <=50