Question: Complete in SQL 1. Find those employees who make more than BLAKE does 2. Find those jobs whose average salary is more than the average

Complete in SQL 1. Find those employees who make more than BLAKE does 2. Find those jobs whose average salary is more than the average salary of the entire company. 3. Find the employees who are making more than everybody in SALES department 4. Find the total number of employees who have never received commissions 5. Find the name of those departments whose employees earn more than 2100 dollars on the average 6. Find the number of employees whose name starts with J in each department 7. Find those departments whose minimum salary is less than 1800 8. Find those job categories whose average salary is more than 1200 9. Find those job categories whose maximum salary among the people hired after 1980 is more than 2500 10. Find the minimum salary of each department among the people who was hired before 1980?

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!

The Starbucks integrative case provides you with an opportunity to apply the entire six-step analysis framework of this textbook to Starbucks, an interesting, profitable, and growing company....

Complete the following in SQL: 1. Find employees who were hired in the same year as BLAKE 2. Find the number of employees hired in January of all years 3. Delete those employees whose name starts...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

2. For the Company Projects DB, (see Appendix), write SQL queries to answer perform each of the following actions. a) For each department whose average employee salary is more than $30,000, retrieve...

GEIT 3341: Database 3. Find the first name, middle initial and last name of all employees who work on exactly 2 projects. (2.5 points) 2. Produce a relation showing the department name and the name...

Database using cmd. Solve this in 1 hour as soon as possible. REGIONS REGION 10 REGION_NAME DEPARTMENTS DEPARTMENT ID DEPARTMENT_NAME MANAGER D LOCATION D EMPLOYEES EMPLOYEE ID FIRST NAME LAST NAME...

A n s w er t h e f o ll o w in g q u es t i o n scorrec tl y : Attachments., 1.According to a WSJ article, in Britain, drug companies are paying for nurses to study patient charts to identify people...

To study the relationship between personal characteristics and salary, a data set containing information on salaries and personal characteristics of a sample of employees of a large company has been...

-- DESCRIPTION -- This script creates the SQL*Plus demonstration tables in the -- current schema. It should be STARTed by each user wishing to -- access the tables. SET TERMOUT ON PROMPT Building...

CSIS 112: Lab \# 3 WePaintHouses LLC: Employee HR Information Great news! You did such a wonderful job creating the painting estimator program that you have been hired by WePaintHouses LLC ance...

Using Pubs (or Pubs2) sample tables to create SQL statements (1 per question) to accomplish the following (command and output required): List the first name, last name and author ID of the authors...

Te average human chromosome contains about 1 108 bp of DNA. (a) If each base pair has a mass of about 660 daltons and there are about 2 g of protein (histones plus nonhistones) per gram of DNA, how...

Joe Seacat has just rented space in a strip mall. In this space, he will open a photo graphy studio, to be called Picture This! A friend has advised Joe to set up a double-entry set of accounting...

Define sensitivity analysis.

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

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...