(Solved) : Create Table Employees Employeeid Number 6 Primary Key Null Firstname Varchar 10 Lastname Q30316915 . . . .

CREATE TABLE EMPLOYEES(

EMPLOYEE_ID NUMBER(6) PRIMARY KEY NOT NULL,

FIRSTNAME VARCHAR(10),

LASTNAME VARCHAR(10)NOT NULL,

JOB_ID VARCHAR(10),

SALARY NUMBER(8,2),

MANAGER_ID NUMBER(6),

DEPARTMENT_ID NUMBER(4));

INSERT INTO EMPLOYEES VALUES(100,’STEVEN’,’KING’,’AD_PRES’,24000,NULL,90);

INSERT INTO EMPLOYEES VALUES(101,’NENA’,’KOCHAR’,’AD_VP’,17000,100,90);

INSERT INTO EMPLOYEES VALUES (102,’LEX’,’DEHAAN’,’AD_VP’,17000,100,90);

INSERT INTO EMPLOYEES VALUES(103,’ALEXANDER’,’HUNOLD’,’IT_PROG’,NULL,101,60);

INSERT INTO EMPLOYEES VALUES(104,’BRUCE’,’ERNST’,’IT_PROG’,6000,102,60);

INSERT INTO EMPLOYEES VALUES(107,’DIANA’,’LORENTZ’,’IT_PROG’,4200,103,60);

INSERT INTO EMPLOYEES VALUES(124,’KEVIN’,’MOURGOS’,’ST_MAN’,5800,100,50);

INSERT INTO EMPLOYEES VALUES(141,’TRINA’,’RAJS’,’ST_CLERK’,3500,124,50);

INSERT INTO EMPLOYEES VALUES(142,’CURTIS’,’DAVIES’,’ST_CLERK’,3100,124,50);

INSERT INTO EMPLOYEES VALUES(143,’RANDALL’,’MATOS’,’ST_CLERK’,2600,124,50);

INSERT INTO EMPLOYEES VALUES(144,’PETER’,’VARGAS’,’ST_CLERK’,2500,124,50);

INSERT INTO EMPLOYEES VALUES(149,’ELENI’,’ZLOTKEY’,’SA_MAN’,10500,100,80);

INSERT INTO EMPLOYEES VALUES(174,’ELLEN’,’ABEL’,’SA_REP’,11000,149,50);

INSERT INTO EMPLOYEES VALUES(176,’JONATHAN’,’TAYLOR’,’SA_REP’,8600,149,80);

INSERT INTO EMPLOYEES VALUES(178,’KIMBERLEY’,’GRANT’,’SA_REP’,7000,149,NULL);

INSERT INTO EMPLOYEES VALUES (200,’JENNIFER’,’WHALEN’,’AD_ASST’,4400,101,10);

INSERT INTO EMPLOYEES VALUES(201,’MICHAEL’,’HARTSTEIN’,’MK_MAN’,13000,100,20);

INSERT INTO EMPLOYEES VALUES(202,’PAT’,’FAY’,’MK_REP’,6000,201,20);

INSERT INTO EMPLOYEES VALUES(205,’SHELLEY’,’HIGGINS’,’AC_MGR’,12000,101,110);

INSERT INTO EMPLOYEES VALUES(206,’WILLIAM’,’GIETZ’,’AC_ACCOUNT’,8300,205,110);

CREATE TABLE LOCATIONS(LOCATION_ID NUMBER(4) PRIMARY KEY NOT NULL,STREET_ADDRESS VARCHAR(20),POSTAL_CODE VARCHAR(10),CITY VARCHAR(15) NOT NULL,STATE_PROVINCE VARCHAR(10),COUNTRY_ID CHAR(2));INSERT INTO LOCATIONS VALUES(1400, ‘2014 JABBERWACKY RD’,26192, ‘SOUTHLAKE’, ‘TEXAS’, ‘US’);INSERT