Question: 11. Use partial inquiry to find employees with the same position as employees in Chicago. What commando to use? +--------+----------+ | ename | job |

11. Use partial inquiry to find employees with the same position as employees in Chicago. What commando to use? +--------+----------+ | ename |

11. Use partial inquiry to find employees with the same position as employees in Chicago. What commando to use?

+--------+----------+

| ename | job |

+--------+----------+

| James | Clerk |

| Adams | Clerk |

| Smith | Clerk |

| Miller | Clerk |

| Blake | Manager |

| Clark | Manager |

| Jones | Manager |

| Martin | Salesman |

| Turner | Salesman |

| Ward | Salesman |

| Allen | Salesman |

+--------+----------+

12. Use inline view to list percentage salary for each employee in relation to total salary. What commando to use?

+--------+--------+--------------------+

| Name | Salary | sal/tot_sal*100 |

+--------+--------+--------------------+

| Smith | 800 | 2.756244616709733 |

| James | 950 | 3.273040482342808 |

| Adams | 1100 | 3.7898363479758825 |

| Ward | 1250 | 4.3066322136089585 |

| Martin | 1250 | 4.3066322136089585 |

| Miller | 1300 | 4.478897502153316 |

| Turner | 1500 | 5.167958656330749 |

| Allen | 1600 | 5.512489233419466 |

| Clark | 2450 | 8.440999138673558 |

| Blake | 2850 | 9.819121447028424 |

| Jones | 2975 | 10.249784668389319 |

| Ford | 3000 | 10.335917312661499 |

| Scott | 3000 | 10.335917312661499 |

| King | 5000 | 17.226528854435834 |

+--------+--------+--------------------+

13. Use inline view to list percentage salary for employees per. department in relation to total salary sorted by increasing percentage. What commando to use?

+-------------+-------+------------------------+

| Departement | Sum | sum(sal)/tot_sal * 100 |

+-------------+-------+------------------------+

| Accounting | 8750 | 30.1464254952627 |

| Research | 10875 | 37.46770025839793 |

| Sales | 9400 | 32.38587424633936 |

+-------------+-------+------------------------+

+ emp Vis alle Antall rader.25 v Filter rader Ski denne tabellen Sorter etter nkkelIngen + Innstillinger empno ename job mgr hiredate sal1 comm deptno O-P RedigerKopierSlett 7839 King President NULL 0000-00-00 00:00:00 5000 NULL Rediger 3 Kopier Slett 7788 Scott Analyst 7566 0000-00-00 000000 3000 NULL Rediger KopierSlett 7902 Ford Analyst 7566 0000-00-00 00:00:00 3000 NULL Rediger Kopier Slett 7566 Jones Manager 7839 0000-00-00 00 0000 2975 NULL Rediger Kopier Slett 7698 Blake Manager 7839 0000-00-00 0000:00 2850 Rediger 3 Kopier Slett 7782 Clark Manager 7839 0000-00-00 00 0000 2450 Rediger Kopier Slett 7499 Allen Salesman 7698 1981-02-2000.00:00 600 300 Rediger Kopier slett 7844 Turner Salesman 7698 0000-00-00 00:00:00 1500 RedigerKopier Slett 7934 Miller Clerk 7782 0000.00-00000000 1300 NULL Rediger Kopier lett 7654 Martin Salesman 7698 0000-00-00 00:00:00 1250 1400 2 3 P RedigerKopierSlett 7521 Ward Salesman 7698 0000-00-00 00:00:00 1250 500 1100 NULL P RedigerKopier Slett 7900 James Clerk 7698 0000-00-00 00:00:00 950 NULL Rediger 3 KopierSlett 7876 Adams Clerk 7788 0000-00.00 00.00.00 2 Rediger Kopiereslett 7369 Smith Clerk 7902 1980-12-17000000 800 NULL +emp O Vis alle Antall rader 25 Filter rader Ski denne + Innstillinger HT- deptno dname loc -' Rediger Kopier+Slett trp RedigerKopiere) Slett 1 Accounting New York 2 Research Dallas Rediger rp Rediger 3c Kopier Kopier Slett 3 Sales Chicago 4 Operations Boston Slett

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!

SQL statements. 1. Show employees who do not have commission. What commando to use? 2. Show today's date and time in Norwegian format. What commando to use? 3. Show employees who do not have 500 in...

I have posted this two times now, and have gotten the wrong answers two times. 1. Show today's date and time in Norwegian format. What commando to use? 2. Show employees who do not have commission....

1. Show today's date and time in Norwegian format. What commando to use? 2. Show employees who do not have commission. What commando to use? 3. Show employees who do not have 500 in commission. What...

Show today's date and time in Norwegian format. What commando to use? Show employees who do not have commission. What commando to use? Show employees who do not have 500 in commission. What commando...

Using the database(SQL), write the queries for all the following questions. More information is provided at the end. From the Emp table, write a query to find those employees whose commission is more...

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

I need sql query Question 1. Find employees' data, hired on MANAGER position in NEW YORK or CHICAGO. Sort them by descending salaries 3. Create all pairs of employees' names who work in the same...

SQL Queries to Develop Develop SQL statements using the EMP and DEPT tables explained in Oracle APEX. Use Oracle APEX to try out and test each SQL statement. Note that SAL is a month salary. Send in...

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out and test each SQL...

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

Iowa imposes a tax on the operation of slot machines. The rate is graduated based on slot machine revenues. Can Iowa charge a higher maximum rate to racetrack owners than it does to riverboat owners...

The trial balance of Lakewood Inc. included the following accounts as of December 31, 2021 Sales revenue Interest revenue. Gain on sale of investments Cost of goods sold Selling expense Loss on...

nowing this information solve the following: Interest on Credit Cards. Eileen, who is currently paying $ 1 , 7 4 8 per year in finance charges to her credit card company, wants a car that costs $ 7 ,...

Exchanging Files You are attempting to oth to send files from your phone to your useWhen you try sending the files from your comp it does not display your computer as a device to which it can send...

LO40.1 List and discuss several key facts about international trade.

2. Distinguish among land-, labor-, and capital-intensive goods, citing an example of each without resorting to book examples. How do these distinctions relate to international trade? How do...

3. Suppose that the money supply is $1 trillion and money velocity is 4. Then the equation of exchange would predict nominal GDP to be: LO39.1 a. $1 trillion. b. $4 trillion. c. $5 trillion. d. $8...