1. CREATE TABLE "EMPLOYEE" (
2.     "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
3.     "STREET"        VARCHAR2(100) NOT NULL,
4.     "CITY"          VARCHAR2(100) NOT NULL
5. )
6.  
7. ---------------------------------------------------------------
8.  
9. CREATE TABLE "COMPANY" (
10.     "COMPANY-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
11.     "CITY"          VARCHAR2(100) NOT NULL
12. )
13.  
14. ----------------------------------------------------------------
15.  
16. CREATE TABLE "MANAGES" (
17.     "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
18.     "MANAGER-NAME"          VARCHAR2(100) NOT NULL
19. )
20.  
21. ---------------------------------------------------------------
22.  
23. CREATE TABLE "WORKS" (
24.     "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
25.     "COMPANY-NAME"          VARCHAR2(100) NOT NULL,
26. "SALARY"  NUMBER(20) NOT NULL
27. )
28.  
29. ---------------------------------------------------------------
30.  
31. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANY_NAME='FIRST BANK CORPORATION';
32.  
33. -----------------------------------------------------------------
34.  
35. UPDATE WORKS SET SALARY=SALARY+SALARY*0.1;
36.  
37. -----------------------------------------------------------------
38.  
39. SELECT EMPLOYEE.EMPLOYEE_NAME, EMPLOYEE.STREET, EMPLOYEE.CITY
40. FROM EMPLOYEE
41. INNER JOIN WORKS
42. ON EMPLOYEE.EMPLOYEE_NAME = WORKS.EMPLOYEE_NAME
43. WHERE COMPANY_NAME='FIRST BANK CORPORATION';
44.  
45. ----------------------------------------------------
46.  
47. SELECT EMPLOYEE.EMPLOYEE_NAME
48. FROM EMPLOYEE
49. INNER JOIN COMPANY
50. ON EMPLOYEE.CITY = COMPANY.CITY;
51.  
52. ----------------------------------------------------
53.  
54. SELECT COMPANY.COMPANY_NAME, COUNT(WORKS.EMPLOYEE_NAME)
55. FROM COMPANY
56. INNER JOIN WORKS
57. ON WORKS.COMPANY_NAME=COMPANY.COMPANY_NAME
58. GROUP BY COMPANY.COMPANY_NAME HAVING COUNT(WORKS.EMPLOYEE_NAME)>30;
59.  
60.  
61.  
62.  
63.  
64.