You are writing a query about hospital encounters using the following FROM clause: FROM PAT_ENC HSP peh CLARITY_DEP dep ON peh.DEPARTMENT_ID = dep.DEPARTMENT_ID DEPARTMENT_ID is never NULL in either table, and for every DEPARTMENT_ID in PAT_ENC_HSP, there is a matching DEPARTMENT_ID in CLARITY_DEP. Assuming no additional filtering, which join type must you use? A. You must use either an INNER JOIN or a LEFT OUTER JOIN, and either would return the same results B. You must use an INNER JOIN C. You must use a LEFT OUTER JOIN D. You must use a CROSS JOIN

A Cartesian join between a table with 5 records and a table with 10 records returns how many rows?

My SQL WORKBENCH **Please note that you may actually use as many tables as you need. You are not limited to use only twotables.Example:SELECT *FROM DEPARTMENTS;SELECT *FROM EMPLOYEES;Now join departments and employees tables.SELECT FIRST_NAME, DEPARTMENT_NAMEFROM EMPLOYEES, DEPARTMENTSWHERE EMPLOYEES.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID;NOTE: If you omit the join condition, the result will be the Cartesian Product of the two tables. A CartesianProduct joins all rows of the first table with all rows of the second table.That is if the first table has n rows and the second table has m rows, the output will have n*m rows.The following query will produce a Cartesian Product:SELECT FIRST_NAME, DEPARTMENT_NAMEFROM EMPLOYEES, DEPARTMENTS;**When table names are long, qualifying column names might be very time consuming. Usually peopleprefer to use table aliases for this purpose.Example: List the name of all employees who work for 'Purchasing' departmentSELECT E.FIRST_NAME "EMPLOYEE…