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
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 employees 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.
_________________________________________________________________________
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started