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