Question: Can anyone helps me with this SQL. 1- Write a SQL query to display list of unique first and last names of students, admins and

Can anyone helps me with this SQL.

1- Write a SQL query to display list of unique first and last names of students, admins and instructors.

2-Write a SQL query to display list of employee IDs along with their salary. Also, display max and min. salary currently being paid to the employees.

3.Write SQL query to display records of employees (IDs and Salary) who are earning less than $5000. Also, display total number of employees getting less than $5000

4.Display records of employees (IDs, hire_date, Department ID) who joined company in year 1998. Also, display how many from these belong to Department ID 8.

5.Write a SQL query to display list of unique first and last names of admins, instructors and employees (from Database) . Conditions: a. Instructor's first name must start with 'a' b. Employee's first name must end with 'y' and last name must have at least one occurrence of letter 'a'

6.Write a SQL query to display how many employees were hired in 1987, 1998, 1999 and 2000

7.Write a SQL query to display only year part when employees were hired. Also, display total number of years (when hiring was done) at the end.

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!

Create a query that retrieves total number of allergies per patient. Your query must display patient first and last names. Your output must resemble the one below Question 1 [05] Create a query that...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

Part 1 Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons. books ( book_id int, title varchar(20), author_last_name...

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...

Use the attached code to create and populate ConstructCo Write the SQL queries to answer the following questions based on the ConstructCo database. Save your queries in a text or a Word file and...

Before starting these problems, update the JustLee Books database by executing the JLDB _ Build _ 9 . sql script, otherwise, your solutions might not work! Note: In this module, it is assumed that...

hello can you assist me with this problem Write the SQL queries to answer the following questions based on the ConstructCo database. Save your queries in a text or a Word file and submit here. 1....

Suppose the following database Organization containing the below three tables: work ID 1 2 Bonus BONUS DATE 2/20/2016 000 6112016 000 2/20/2016 000 2/20/2015 0.00 6/11/2016 0.00 BONUS. AMOUN 5000...

Indicate how a fast-food chain can estimate the price elasticity of a proposed new product such as a new chicken sandwich.

Although direct distribution often results in lower prices, does it have disadvantages for buyers?

a There are potential security issues when using microprocessor-controlled devices in the home. Describe these issues and explain how they can be mitigated. b Indicate which of the following...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Do you favor debt forgiveness to all the DVCs, just the poorest ones, or none at all? What incentive problem might debt relief create? Would you be willing to pay $20 a year more in personal income...

KEY QUESTION Because real capital is supposed to earn a higher return where it is scarce, how do you explain the fact that most international investment flows to the IACs (where capital is relatively...

KEY QUESTION Use Figure 16W.3 (changing the box labels as necessary) to explain rapid economic growth in a country such as South Korea or Chile. What factors other than those contained in the figure...