Question: localhost/localhost.phpMyAdmin Employeeinfo Table: EmpID EmpFrame Empl.name Department Project Address DOB Gender 1 Sanjay Mehra HR P1 Hyderabad(HYD) 01/12/1976M 2 Ananya Mishra Admin P2 Delhi(DEL) 02/05/1968

localhost/localhost.phpMyAdmin Employeeinfo Table: EmpID EmpFrame Empl.name Department Project Address DOB Gender 1 Sanjay Mehra HR P1 Hyderabad(HYD) 01/12/1976M 2 Ananya Mishra Admin P2 Delhi(DEL) 02/05/1968 F 3 Rohan Diwan Account P3 Mumba (BOM) 01/01/1980 M 4 Sonia Kulkarni HR P1 Hyderabad(HYD) 02/05/1992 F Ankit Kapoor Admin P2 Delhi(DEL) 03/07/1994 M Employee Position Table: EmplD 1 2 EmpPosition Manager Executive Manager Lead Executive DateOfJoining 01/05/2022 02/05/2022 01/05/2022 02/05/2022 01/05/2022 Salary 500000 75000 90000 85000 300000 3 2 1 1. Write a query to fetch the EmpFname from the Employeeinfo table in upper case and use the ALIAS name as EmpName. 2. Write a query to fetch the number of employees working in the department HR 3. Write a query to retrieve the first four characters of Emplname from the Employeelnfo table. 4. Write q query to find all the employees whose salary is between 50000 to 100000. ASUS
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
