CREATE table "EMPLOYEE" (
    "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
    "STREET"        VARCHAR2(100) NOT NULL,
    "CITY"          VARCHAR2(100) NOT NULL
)

---------------------------------------------------------------

CREATE table "COMPANY" (
    "COMPANY-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
    "CITY"          VARCHAR2(100) NOT NULL
)

----------------------------------------------------------------

CREATE table "MANAGES" (
    "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
    "MANAGER-NAME"          VARCHAR2(100) NOT NULL
)

---------------------------------------------------------------

CREATE table "WORKS" (
    "EMPLOYEE-NAME" VARCHAR2(100) NOT NULL PRIMARY KEY,
    "COMPANY-NAME"          VARCHAR2(100) NOT NULL,
"SALARY"  NUMBER(20) NOT NULL
)

---------------------------------------------------------------

SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANY_NAME='FIRST BANK CORPORATION';

-----------------------------------------------------------------

UPDATE WORKS SET SALARY=SALARY+SALARY*0.1;

-----------------------------------------------------------------

SELECT EMPLOYEE.EMPLOYEE_NAME, EMPLOYEE.STREET, EMPLOYEE.CITY
FROM EMPLOYEE
INNER JOIN WORKS 
ON EMPLOYEE.EMPLOYEE_NAME = WORKS.EMPLOYEE_NAME
WHERE COMPANY_NAME='FIRST BANK CORPORATION';

----------------------------------------------------

SELECT EMPLOYEE.EMPLOYEE_NAME
FROM EMPLOYEE
INNER JOIN COMPANY 
ON EMPLOYEE.CITY = COMPANY.CITY;

----------------------------------------------------

SELECT COMPANY.COMPANY_NAME, COUNT(WORKS.EMPLOYEE_NAME) 
FROM COMPANY 
INNER JOIN WORKS 
ON WORKS.COMPANY_NAME=COMPANY.COMPANY_NAME 
GROUP BY COMPANY.COMPANY_NAME HAVING COUNT(WORKS.EMPLOYEE_NAME)>30;