create table EMPLOYEE(EMP_ID int,FIRST_NAME VARCHAR(200),LAST_NAME VARCHAR(100),SALARY VARCHAR(299),DOJ DATE,DEPT VARCHAR(200)
);
INSERT INTO EMPLOYEE VALUES(1,"JI","BIN","10K","2000/03/22","BSC");
INSERT INTO EMPLOYEE VALUES(2,"SREE","RAG",'55K','1999/02/12','BCA');
INSERT INTO EMPLOYEE VALUES(3,'RAVI','RAJ','20K','1998/01/01','BCOM');
INSERT INTO EMPLOYEE VALUES(4,'MEENA','KS','15K','1997/09/15','BA');
INSERT INTO EMPLOYEE VALUES(5,'SITA','JD','12K','1997/04/30','BED');
SELECT * FROM EMPLOYEE;
select FIRST_NAME as EMPLOYEE_name from EMPLOYEE;
select * from EMPLOYEE where FIRST_NAME like 'r%';
select count(SALARY) from EMPLOYEE where SALARY > '20K' and DEPT = 'bsc';