You are performing an INNER JOIN on two tables on the employee_id column. The left table is employees, and the right table is machines. Which of the following queries has the correct INNER JOIN syntax?1 pointINNER JOIN machines ON employees.employee_id = machines.employee_idSELECT *FROM employees;SELECT *FROM employeesINNER JOIN machines ON employees.employee_id = machines.employee_id;SELECT *FROM employeesINNER JOIN ON employees.employee_id = machines.employee_id;SELECT *FROM employeesINNER JOIN machines WHERE employees.employee_id = machines.employee_id;

Question 3In the following query, which join returns all records from the employees table, but only records that match on employee_id from the machines table?SELECT *FROM employees _____ machines ON employees.employee_id = machines.employee_id;1 pointRIGHT JOINFULL OUTER JOINLEFT JOININNER JOIN

For the following table:Employees (EmployeeId, EmployeeName, HireDate, Salary, ReportsTo)You want to identify the supervisor to which each employee reports. You write the following query.SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS [SuperVisorName] FROM Employees eYou need to ensure that the query returns a list of all employees and their respective supervisor. Which join clause should you use to complete the query?INNER JOIN Employees s ON e.ReportsTo = s.EmployeeId;INNER JOIN Employees s ON e.EmployeeId = s.EmployeeId;INNER JOIN Employees s ON e.EmployeeId = s. ReportsTo;RIGHT JOIN Employees s ON e. EmployeeId = s. ReportsTo;

The INNER JOIN clause?Returns all rows that have matching value in the field on which the 2 tables are joined.Returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.Returns all rows from 2 tables.Returns all the matching rows from 2 tables.

You encounter the following statements:SELECT e1.ename|| 'works for '||e2.ename "Employees and their Managers" FROM emp e1, emp e2 WHERE e1.mgr=e2.empno;  What kind of join is this?

You have two tables employee and department that have 10 records. In the given context, determine the type of join being used in the query given alongside.SELECT employee.emp_id, department.emp_id, name, dept_id FROM employee, department; Inner JoinOuter JoinEqui-JoinCartesian Join