Very difficult SQL query
- by db666
For the following table definitions:
Name Null? Type Comments
------------------------------- -------- ---- ------------------------------------
ENUM NOT NULL NUMBER(4) ENUM should not exceed a length of 4.
ENAME CHAR(15)
ADDRESS CHAR(25) ADDRESS should not exceed 25 characters.
SALARY NUMBER(5)
OFFICE CHAR(4)
DNUM NOT NULL NUMBER(4) Department which this employee belongs to
department
Name Null? Type Comments
------------------------------- -------- ---- -------------------------------------
DNUM NOT NULL NUMBER(4)
DMGR NOT NULL NUMBER(4) Department manager
DNAME NOT NULL CHAR(15)
project
Name Null? Type Comments
------------------------------- -------- ---- -------------------------------------
PNUM NOT NULL NUMBER(4)
PMGR NOT NULL NUMBER(4) Project manager
PTITLE NOT NULL CHAR(15)
emp_proj
Name Null? Type
------------------------------- -------- ----
PNUM NOT NULL NUMBER(4)
ENUM NOT NULL NUMBER(4)
I have to write SQL query which will find the names of employees who do not share an office but work on the same project, and have different salaries... I've spent last three days trying to figure out something, but no idea as far. I will appreciate any advice.
