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;