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

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 Databases Questions!

Please solve in SQL database 1) Return all employees whose last names start with St. 2) I was hired by Oracle after May 1998 but before June of 1999. My salary is less than $8000 per month, and I...

please any help for this SQL query *) Display employee names and dependent information. Also include those employees that dont have any dependent. *) Find out the employee names and number of years...

Consider we have a database with 7 relations whose schema is shown as below: Customer = { cid , f name, lname , birthday, income } Account = { accno , type, balance, branch no } Owns = { cid , accno...

Bookmark EMP_1 EMPLOYEE TABLE JOB TABLE Problem: Use SQL commands to answer Problems 112. (Take screen shot of commands and tables) 1. Write the two SQL code command sequences required to: a. Create...

EMP_1 EMPLOYEE TABLE JOB TABLE Problem: Use SQL commands to answer Problems 112. 1. Write the two SQL code command sequences required to: a. Create a temporary table named TEMP_1 whose structure is...

Please i need a SQL query if possible 1) Display all employee names (last name and first name separated by a comma and a space) and salary with appropriate column aliases. Also, for yearly salary...

The Employees table contains six fields. The EmpNum, Rate, and DeptCode fields are numeric. The LastName, FirstName, and Status fields contain text. The Status field contains either the letter F (for...

10. write a SQL query to find those employees who work either in department 70 or 90. Return full name (first and last name), department id. 11. write a SQL query to find those employees who work...

Table Name: DEPT D.id DName 111 Sales Building First Second 112 Accounts 113 First Service HR 114 Second Table Name: EMP Eld Ename Do Depno 113 E101 Ahmed E102 Gaith 111 E103 Hafsa Salary 300.000 625...

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Crede Company budgeted selling expenses of $30,000 in January, $35,000 in February, and $40,000 in March. Actual selling expenses were $31,200 in January, $34,525 in February, and $46,000 in March....

A 1.20-kg piece of cheese is placed on a vertical spring of negligible mass and force constant k = 1800 N/m that is compressed 15.0 cm. When the spring is released, how high does the cheese rise from...

Risk is always an important factor to consider when making investment decisions. False I True

Presented below are selected transactions of Tamarisk Company. Tamarisk sells in large quantities to other companies and also sells its product in a small retail outlet. March 1 , Sold merchandise on...

=+ Should the MNE belong (why, why not)?

=+What does membership entail, do most employers join, and can the firm avoid joining?

=+ What is the role of government in bargaining?