Question: sql command Q1. Using hr schema, write a query to display first name, last name, department name, city of the department and the street address

sql command

Q1. Using hr schema, write a query to display first name, last name, department name, city of the department and the street address for each employee who earns more than 10000$ per month. (1.5)

Q2. Write a query to display employees name, his salary, the difference between his salary and the lowest salary for his job, and the difference between his salary and the highest salary in his job. (1.5)

Q3. Write a query to display each street address with the number of departments exist in it. Exclude departments 100, 80, 50 and 30 from the summations. (2)

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!

Q1. Using hr schema, write a query to display first name, last name, department name, city of the department and the street address for each employee who earns more than 10000$ per month. (1.5) Q2....

The following is the structure of the tables provided by Oracle in Human Resource Schema (HR). Note: Columns in RED color indicate primary key(s). Q1: Write a query to display first name, job id and...

Create HR database with the following tables. 1 2. Table 2: Departments 5. Table 5: Regions \begin{tabular}{|l|l|l|l|} \hline Column Name & Null? & Type \\ \hline REOICN_1D & NOr NJLL & NUNBER \\...

Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a semicolon after each SQL statement, a requirement for SQL...

SQL Question 5 Use the tables in your schema. Write a query that produces the following for each employee whose last name begins with an R: earns monthly but wants . Use a function to format the...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

If my understanding is correct, I have provided the DB schema The LargeCo database below stores data for a company that sells paint products. The company tracks the sale of products to customers....

My question is how do I write the SQL Querys for these problems? FIGURE P7.27 THE CH07_LARGECO ERD \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ LGCUSTOMER } \\ \hline PK & Cust_Code \\ \hline...

Write 10 queries (see assignment instruction for detailed requirements) to query the STUDENT schema you created for practice lab 1. Your Select Statements should run error-free and should be valid....

USE the HR2550 Database bellow , and write a single script (with comments at the top) t PRINT 1A. Display the first name, last name, department number and department name, for all employees including...

How can we demonstrate that the different dimensions of culture comprise a whole?

1. What do you like about Dee Dee Fisher? Why? 2. What do you dislike about Dee Dee Fisher? Why? 3. What boundaries did Fisher break that most people have not? 4. What do you think Fisher should do...

The following data are available relating to the performance of Rand Stock Fund and the market portfolio: RandMarket PortfolioAverage return 1 5 . 3 % 1 4 % Standard deviations of returns 2 6 % 2 7 %...

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

What is the basis for Security Concerns in Cloud Computing?

Should Needs and GAP Analyses be equally applied in terms of effort when off-theshelf System Solutions being acquired versus building a custom system using Vendors or internal Programming Staff?

Describe the three main Cloud Computing Environments.