-- For desktop version
DROP TABLE employees;
CREATE TABLE employees(
  TabNum   INT PRIMARY KEY,
  DepNo    INT,
  EName    VARCHAR(40),
  post     VARCHAR(40),
  salary   INT,
  born     DATE,
  phone    VARCHAR (40)
);
INSERT INTO employees VALUES(988, 1, 'John Smith', 'Head of Department', 48500, '01-02-1970', '115-26-12');
INSERT INTO employees VALUES(909, 1, ' Bruce Robertson', 'Lead Programmer', 48500, '20-10-1981', '115-91-19');
INSERT INTO employees VALUES(829, 1, ' Curtis Cook', 'Economist', 43500, '03-10-1978','115-26-12' );
INSERT INTO employees VALUES(819, 1, ' Carl Murphy', 'Economist', 43500, '13-11-1985','115-91-19' );
INSERT INTO employees VALUES(100, 2, ' Claudia Sinclair', 'Programmer', 46500, '16-10-1982', NULL);
INSERT INTO employees VALUES(110, 2, ' Constance London', 'Accountant', 42880, '22-05-1975','115-46-32' );
INSERT INTO employees VALUES(023, 2, ' Daisy Nail', 'Chief Accountant', 59240, '24-11-1954','114-24-55' );
INSERT INTO employees VALUES(130, 2, ' Dexter Round', 'Accountant', 42880, '1-07-1979','115-46-32');
INSERT INTO employees VALUES(034, 3, ' Deborah Waite', 'Clerk', 32000, '24-04-1988', NULL);
INSERT INTO employees VALUES(002, 3, ' Douglas Fairy', 'Head of Department', 48500, '08-06-1948', '115-12-69' );
INSERT INTO employees VALUES(056, 5, ' Richard Hardman', 'Director', 80000, '05-05-1968','115-33-44');
INSERT INTO employees VALUES(087, 5, ' Wilma Leapman', 'Secretary', 35000, '16-09-1990','115-33-65');
INSERT INTO employees VALUES(088, 5, ' Stacey Longman', 'Deputy Director', 70000, '18-04-1974','115-33-01' );
SELECT * FROM employees;


-- For Live SQL
DROP TABLE employees;
CREATE TABLE employees(
  TabNum   INT PRIMARY KEY,
  DepNo    INT,
  EName    VARCHAR(40),
  post     VARCHAR(40),
  salary   INT,
  born     DATE,
  phone    VARCHAR (40)
);
INSERT INTO employees VALUES(988, 1, 'John Smith', 'Head of Department', 48500, '01-FEB-1970', '115-26-12');
INSERT INTO employees VALUES(909, 1, ' Bruce Robertson', 'Lead Programmer', 48500, '20-OCT-1981', '115-91-19');
INSERT INTO employees VALUES(829, 1, ' Curtis Cook', 'Economist', 43500, '03-OCT-1978','115-26-12' );
INSERT INTO employees VALUES(819, 1, ' Carl Murphy', 'Economist', 43500, '13-NOV-1985','115-91-19' );
INSERT INTO employees VALUES(100, 2, ' Claudia Sinclair', 'Programmer', 46500, '16-OCT-1982', NULL);
INSERT INTO employees VALUES(110, 2, ' Constance London', 'Accountant', 42880, '22-MAY-1975','115-46-32' );
INSERT INTO employees VALUES(023, 2, ' Daisy Nail', 'Chief Accountant', 59240, '24-NOV-1954','114-24-55' );
INSERT INTO employees VALUES(130, 2, ' Dexter Round', 'Accountant', 42880, '1-JUL-1979','115-46-32');
INSERT INTO employees VALUES(034, 3, ' Deborah Waite', 'Clerk', 32000, '24-APR-1988', NULL);
INSERT INTO employees VALUES(002, 3, ' Douglas Fairy', 'Head of Department', 48500, '08-JUN-1948', '115-12-69' );
INSERT INTO employees VALUES(056, 5, ' Richard Hardman', 'Director', 80000, '05-MAY-1968','115-33-44');
INSERT INTO employees VALUES(087, 5, ' Wilma Leapman', 'Secretary', 35000, '16-SEP-1990','115-33-65');
INSERT INTO employees VALUES(088, 5, ' Stacey Longman', 'Deputy Director', 70000, '18-APR-1974','115-33-01' );
SELECT * FROM employees;