Online Course Support

Which of the following are valid join queries for Impala? Check all that apply.

Question 7
Which of the following are valid join queries for Impala? Check all that apply.

1 point

SELECT o.office_id as office, AVG(salary) AS avg_salary

FROM california_emp e

JOIN california_offices o ON o.office_id = e.office_id

GROUP BY office

ORDER BY avg_salary;

SELECT name, o.office_id AS office

FROM california_emp e

JOIN california_offices o ON o.office_id = e.office_id

WHERE office = ‘CA009’;

SELECT o.office_id AS office, COUNT(*) AS number_of_employees

FROM california_emp e

JOIN california_offices o ON o.office_id = e.office_id

GROUP BY office;

SELECT name, o.office_id AS office, city

FROM california_emp e

JOIN california_offices o ON o.office_id = e.office_id

ORDER BY office DESC, name DESC;

Similar Posts