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

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!