Question:
Facts: Employee(name,salary,boss,department)
Question: Which employees earn more than their boss ?
Answer:
Please make sure you don’t share the results with your boss! : )
Try the following:
use pubsgocreate table myemployee( name char(30), salary int, boss char(30), department char(15), constraint pk_employee primary key(name)) goinsert into myemployee (name,salary,boss,department)values ('FRANK',50000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('JIM',40000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('JOE',70000,'FRANK','ACCOUNTING')insert into myemployee (name,salary,boss,department)values ('HARRY',80000,'HARRY','MIS')insert into myemployee (name,salary,boss,department)values ('TIM',45000,'HARRY','MIS')insert into myemployee (name,salary,boss,department)values ('TOM',90000,'HARRY','MIS')select e.name as 'Employee', e.salary as 'Employee Salary', boss.name as 'Boss', boss.salary as 'Boss Salary'from myemployee e, myemployee bosswheree.boss = boss.name ande.salary > boss.salary
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
