Question

You need to create a temporary table emp_dept based on the employees and departments tables. The SQL query that can be used is
1)CREATE TEMP TABLE emp_dept as SELECT emp_id emp_Name dept_name
FROM employees INNER JOIN departments USING (department_id).
2)CREATE TABLE emp_dept as SELECT emp_id emp_Name dept_name
FROM employees INNER JOIN departments USING (department_id).
3)CREATE VIEW emp_dept as SELECT emp_id, emp_Name dept_name
FROM employees INNER JOIN departments USING (department_id).
none of the options​

Answer 1

Answer:

THE ANSWER IS IN THE ATTACHMENT

MARK ME AS THE BRAINLIEST ❤

Answer 2

Answer:

CREATE VIEW emp_dept as SELECT emp_id, emp_Name dept_name

FROM employees INNER JOIN departments USING (department_id)

Explanation: