The california_offices and california_emp tables each have a column named office_id. All other columns have unique names between the two tables. Which of the following are valid join queries that Impala would run successfully on the VM, if these tables existed on the VM? Check all that apply.

Question 6
The california_offices and california_emp tables each have a column named office_id. All other columns have unique names between the two tables. Which of the following are valid join queries that Impala would run successfully on the VM, if these tables existed on the VM? Check all that apply.

1 point

SELECT name, e.office_id AS office_id, city, salary

FROM california_offices

JOIN california_emp ON o.office_id = e.office_id;

SELECT name, california_emp.office_id, city, salary

FROM california_emp

JOIN california_offices

ON california_emp.office_id = california_offices.office_id;

SELECT name, office_id, city, salary

FROM california_offices AS o

JOIN california_emp AS e ON o.office_id = e.office_id;

SELECT name, e.office_id AS office_id, city, salary

FROM california_offices AS o

JOIN california_emp AS e ON o.office_id = e.office_id;