Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Employeelnfo EmplD EmpFname EmpLname Department Project Address DOB Gender 1 Sanjay Mehra HR P1 Hyderabad(HYD) 01/12/1976 M 2 Ananya Mishra Admin P2 Delhi(DEL) 02/05/1968 F

image text in transcribed

Employeelnfo EmplD EmpFname EmpLname Department Project Address DOB Gender 1 Sanjay Mehra HR P1 Hyderabad(HYD) 01/12/1976 M 2 Ananya Mishra Admin P2 Delhi(DEL) 02/05/1968 F 3 Roban Diwan Account P3 Mumbai(BOM) 01/01/1980 M 4 Sonia Kulkarni HR P1 Hyderabad(HYD) 02/05/1992 F 5 Ankit Kapoor Admin P2 Delhi(DEL) 03/07/1994 M Employee Position EmplD EmpPosition DateOfJoining 1 2 3 2 1 Manager Executive Manager Lead Executive 01/05/2019 02/05/2019 01/05/2019 02/05/2019 01/05/2019 Salary 500000 75000 90000 85000 300000 Write a query to get the number of employees sorted by department's count in ascending order. * Write a query to retrieve the list of employees working in the same department. Write a query to retrieve the employee with the maximum salary. * Write the query/queries to add a new HR employee *

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions