Question

Use the N2 Corporation database tables to design the following subqueries:
a) Display all employees’ ID, names (Fname Lname format) and their department name who has the same department as Jinku Shaw’s department name.
SQL File: https://pastebin.com/tR98LUb3

Answer 1

I believe the query asks to filter out all employee IDs, names and their Departments who are in the same department as Jinku Shaw.

Since you haven't mentioned it, let's assume the name of the table to be empDB.

The subquery would be,

SELECT employeeID, employeeFName, employeeLName,employeeDept FROM empDB

WHERE employeeDept = (SELECT employeeDept WHERE employeeFName="Jinku" AND employeeLName="Shaw");