Q: list employee name, job, manager name and salary for those whose salary
is more than their manager
The quetion may seem kinda dumb, it's for a class and my professor has a
thing for brain teaser type questions. I attempted doing this with rename
and a natural join but I can't get the rename to work I think. Any help
would be much appreciated.
Thanx
Table Definition: create table emp (empno numeric(4) not null, ename varchar(10) not null, job varchar(10) not null,
mgr numeric(4), hiredate date, sal numeric(6) not null, comm numeric(4), deptno numeric(4) not null, primary
key(empno));
Example Data: values(7369,'Martinez','Clerk',7902,'1990-12-17',2800,null,20);
values(7499,'Jeter','Sales',7698,'1991-02-20',3600,1300,30);
values(7521,'Knoblauch','Sales',7698,'1998-02-22',3250,1500,30);
values(7566,'Torre','Manager',7839,'1991-04-02',4975,null,20);
values(7654,'Strawberry','Sales',7698,'1994-09-28',2250,2400,30);values(7698,'Dimago','Manager',7839,'1995-05-01',
4850,null,30); values(7782,'Williams','Manager',7839,'1997-06-09',4450,null,10);