CREATE TABLE JOB(     
JOB_ID VARCHAR(10),     
JOB_TITLE VARCHAR(15),     
MIN_SALARY INTEGER(8),     
MAX_SALARY INTEGER(8)     
); 

INSERT INTO JOB VALUES('IT_PROG','PROGRAMMER',4000,10000); 

INSERT INTO JOB VALUES('MK_MGR','MARKETING_MGR',9000,15000); 

INSERT INTO JOB VALUES('FI_MGR','FINANCE_MGR',8200,12000); 

INSERT INTO JOB VALUES('FI_ACC','ACCOUNT',4200,9000); 

INSERT INTO JOB VALUES('LEC','LECTURER',6000,17000);

INSERT INTO JOB VALUES('COMP_OP','COMPUTER_OPTR',1500,3000); 

SELECT * FROM JOB WHERE MIN_SALARY>4000;