SQL SYNTAX -

Query 1:

Retrieve the names of all the projects and the First and Last name of all managers if they are working on these projects.

Query 2:

List First and Last name of employees, Name and Number of all projects that have employee working on them. Do not include projects that are controlled by the department located in Stafford and have employee(s) working on them.

DEPARTMENT DEPENDENT DEPT Data Type Default Primary Key Column Name DNUMBER DNAME MGR SSN MGR START DATE DATE Data Type Default Primary Key Column Name ESSN DEPENDENT NAME VARCHAR2(15) No CHAR(4) Column Name Data Type Default Primary Key DEPTNO NUMBER 2.0) No VARCHAR2(14) Yes VARCHAR2(13) Yes CHARI9) RELATIONSHIP VARCHAR2() Yes DEPT LOCATIONS EMPLOYEE Data Type Nullable Default Primary Key Column Name DNUMBER CHAR(4) DLOCATION VARCHAR215) No Data Type CHAR(9) VARCHAR2(15) No VARCHAR201) Yes VARCHAR2(15) No Data Type NUMBER(4,0) No Column Name Default Primary Key Column Name Nullable Default Primary Key VARCHAR2(9) Yes PROJECT HIREDATE DATE NUMBER7,2) Yes NUMBER7,2) Yes Column Name Data Type Nullable Default Primary Key VARCHAR2(50) Yes CHAR(1) NUMBER 102) Yes ADDRESS PNUMBER CHAR4) DEPTNO NUMBER 2,0) Yes PLOCATION VARCHAR2(15) Yes SUPER_SSN CHAR(9) CHAR(4) No CHAR(4) 1-4 1-10 Column Name Data Type Default Primary Key ESSN CHAR4) No NUMBER(4,1) Yes HOURS