Table - EmployeeDetails Empld FullName Managerld DateOfJoining City 121 John Snow 321 01/31/2014 Toronto 321 Walter White 986 01/30/2015 California 421 Kuldeep Rana 876 27/11/2016 New Delhi Table -...


Write an SQL query to fetch those employees who live in Toronto and work under manager with ManagerId – 321.


Write an SQL query to fetch all the employees who either live in California or work under a manager with ManagerId – 321.


Table - EmployeeDetails<br>Empld FullName<br>Managerld<br>DateOfJoining<br>City<br>121<br>John Snow<br>321<br>01/31/2014<br>Toronto<br>321<br>Walter White<br>986<br>01/30/2015<br>California<br>421<br>Kuldeep Rana<br>876<br>27/11/2016<br>New Delhi<br>Table - EmployeeSalary<br>Empld<br>Project<br>Salary<br>Variable<br>121<br>P1<br>8000<br>500<br>321<br>P2<br>10000<br>1000<br>421<br>P1<br>12000<br>

Extracted text: Table - EmployeeDetails Empld FullName Managerld DateOfJoining City 121 John Snow 321 01/31/2014 Toronto 321 Walter White 986 01/30/2015 California 421 Kuldeep Rana 876 27/11/2016 New Delhi Table - EmployeeSalary Empld Project Salary Variable 121 P1 8000 500 321 P2 10000 1000 421 P1 12000

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here