Which of the following statement is used to avoid the situation of having columns with the same name but different data types?

Question

Answer

SELECT last_name, job_title FROM employees e JOIN jobs j ON (e.job_id = j.job_id);

Answer

SELECT last_name, department_name 
 FROM employees CROSS JOIN departments;

Answer

SELECT first_name, last_name, department_id, department_name 
 FROM employees JOIN departments 
 USING (department_id);

Answer

SELECT first_name, last_name, job_id, job_title 
 FROM employees NATURAL JOIN jobs 
 WHERE department_id > 80;

Crowdly