Question

QUERY 5. You are interested in knowing what the salary difference is between CLARE and her boss. Write a query to output the following:- CLARE’S Name, her bosses name, department name, and the difference between her managers salary and her salary

Answer:-

Clare	Boss	DeptName	Salary Difference
Clare	Ned	Marketing	$23,000.00

Answer 1

As you have not provided the schema of the tables. I am solving your problem by taking dummy schema.

Dummy Schema

CREATE TABLE "Employee" (    "EmpName"   TEXT NOT NULL,    "DeptName"   TEXT NOT NULL,    "EmpID"   INTEGER NOT NULL,    "Boss"   TEXT,    "Salary"   REAL NOT NULL,    PRIMARY KEY("EmpID") );

CREATE TABLE "Employee" ( "Clare" TEXT NOT NULL, "DeptName" TEXT NOT NULL, "EmpID" INTEGER NOT NULL, "Boss" TEXT, "Salary" REAL NOT NULL, PRIMARY KEY ("EmpID")

Dummy Table

Boss EmpName Filter DeptName Filter EmpID Filter Salary Filter Filter Ned 27000.00 1 Clare 2 Ned Marketing Marketing 1001 1002 NULL 50000.00

Query

Query -------------- SELECT E1.EmpName as "Clare" , E1.Boss, E1.DeptName, (E2.Salary-E1.Salary) as "Salary Difference" FROM Employee E1, Employee E2 WHERE E1.EmpName="Clare" AND E1.Boss=E2.EmpName;

Query ScreenShot --------------------------- SELECT El. EmpName as "Clare" , El.Boss, El. DeptName, (E2.Salary-El.Salary) as "Salary Difference" FROM Employee El, Employee E2 WHERE El. EmpName="Clare" AND El.Bo33=E2. EmpName;

Output -------------------- Clare Boss DeptName 1 Clare Ned Marketing Salary Difference 23000.0 Result: 1 rows returned in 4ms At line 1: SELECT El. EmpName as "Clare" , El.Boss, El.DeptName, (E2.Salary-El.Salary) as "Salary Difference" FROM Employee El, Employee E2 WHERE El. EmpName="Clare" AND El.BossE2. EmpName;

If you have any doubts regarding the submitted solution, please ask in the comments.

If you are satisfied with the answer, Please rate it and comment accordingly.