please any help for SQL Query??? 1) Find employee names whose last name start ei

Question

please any help for SQL Query???

1) Find employee names whose last name start either with a D or C and second last character of
first name is either an e or a n.
2) List the department name with the least number of employees.
3) List pair of employee names who are having the same qualification order by qualification id.
4) Display each employee’s name, department name, position description, and qualification
description. Which employee is missing? Why?
5) Find the average (two decimal point), highest, lowest and total salary for each department.Name the colomn Average Salary, Maximum Salary and Minimum Salary and Total Salary.
Also display the department id.

_________________________________________________________________________

Explanation / Answer

Solution:

1, and 2 is done please repost others.

Table schema is not given, so I have taken general assumptions for the company database

1)

if you are using Microsoft's SQL server:

2)

SELECT department name FROM Department WHERE MIN(employeeID) GROUP BY departmentID

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.