INDEX S.no, Practical Name Date | Remark/Sign | Greate the lable EMPLOYEE the description offhe student are Insert the record in the EMPLOYEE table ‘Select those tuples from the Employee where the employee salary iS 3 | greater than 10000 and lass than 15000 | Seect those tuples From the Employee where the employes name ig stat from character A Retiove te table in which the tuples are sorted in the increasing 5 _| from of employee salary. ‘Apply he folowing aggregale funclon in the employee salary 6 | column of employee table Wite the query to delete those tuples from the Employee where 7 | Employee aty is London. Write the query to increase the employee salary by 5 percent in the Employee table where employee age is 25 We the query to add a new column employee adress nthe 9 | Employee table where the type of new column is character and size 128. To _| Write the query To dolato the lable Employes 1. Create the table EMPLOYEE the description of the student are Column name Data type Size E_NAME VARCHAR 20 EID VARCHAR 10 E_AGE NUMBER 10 E_SALARY NUMBER. 10 E_PHONENO NUMBER. 10 E_Cmy, VARCHAR 15 SQL> CREATE TABLE EMPLOYEE (E_NAME (20) VARCHAR, E_ID(0)VARCHAR , E_AGE (10) NUMBER , F_SALARY(10) NUMBER, E_PHONENO (10) NUMBER , rE ITVS) VARCHAR);OUTPUT: - SQL> Dese EMPLOYEE ; ‘Name Type E_NAME VARCHAR(20) EID VARCHAR(10) E_AGE NUMBER(10) E_SALARY NUMBER(10) E_PHONENO NUMBER(10) E CITY VARCHAR(15) 2. Insert the following record in the EMPLOYEE table E_NAME | E_ID E_AGE _|E SALARY [E_PHONENO [E_CITY AJAY C1 23 70000 (09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK | C3 25 15000 (09834567888 | INDORE ‘ASHA ca 25 70000 (09811122766 | PUNE RITU ey 28 70000 (09909234567 | BHOPAL SQL> INSERT INTO EMPLOYEE (E_NAME, E_ID E_AGE, E_SALARY,E_PHONENO , E_CITY) VALUES (+AJAY*, C1, 23 , 10000, 09854345511, BHOPAL); One row created SQL> INSERT INTO EMPLOYEE (E_NAME, E_ID,E_AGE, E_SALARY,E_PHONENO , E_CIry ) VALUES (-PRATEEK", C2. 24 , 12000, 09823453333. BHOPAL):SQL> INSERT INTO EMPLOYEE (£_NAME, E_ID E_AGE, E_SALARY, E_PHONENO , E_CITY ) VALUES (‘NAITIK’, C3 , 25 , 15000, 09834567888, INDORE); ‘One row created (ename SQL> INSERT INTO EMPLOYE! ciry ) VALUES (+ 1D E_AG HONENO , *, C4, 25, 10000, 09811122766, PUNE) ‘One row created SQL> INSERT INTO EMPLOYEE (E_NAME, E_ID, E_AGE, E_ SALARY, E_PHOD E_cITY ) VALUES (‘RITU’, C5, 28 , 10000, 09909234567, BHOPAL); OUTPUT: SQL>SELECT * FROM EMPLOYEE; E.NAME EID EAGE ESALARY EPHONENO — E_CITY AJAY ca 2B 10000 09854345511 BHOPAL PRATEEK C224 12000 09823453333 = BHOPAL. NAITIK C328, 15000 09834567888 INDORE ASHA ct 25 10000 09811122766 = PUNE. RITU cs 8, 10000, 09909234567 BHOPAL3. Select those tuples from the Employee where the employee salary is greater than 10000 and less than 15000, E.NAME [EID |E_AGE | E SALARY |E PHONENO|E CITY AJAY Ci 23 10000 (09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK [C3 25 15000 (09634567888 [INDORE ‘ASHA ca 25 10000 (09611122766 | PUNE RITU C5 28 10000 (09909234567 | BHOPAL SQL > SELECT * FROM EMPLOYEE WHERE E_SALARY BETWEEN 10000 AND 15000; OuTpUT:- ENAME EID E_AGE ESALARY EPHONENO E_CITY PRATEEK C2 M4 12000 09823453333 = BHOPAL 4, Select those tuples from the Employee where the employee name is start from character A. E_LNAME [EID E_AGE _|E_SALARY |E_PHONENO |E CITY AJAY ct 23 70000 (09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK 3 2 15000 (09834567888 | INDORE ASHA C4 25 70000 09817122766 | PUNE RITU ce 28 70000 (09909234567 | BHOPAL SQL > SELECT * FROM EMPLOYEE WHERE E_NAME LIKE ‘A %" ; OUTPUT: E.NAME EID E_AGE ESALARY E_PHONENO — E_CITY AJAY cl 2B 10000 (09854345511 BHOPAL, ASHA cs 25 10000 09811122766 = PUNE5. Retrieve the table in which the tuples are sorted in the increasing from of employee salary. E.NAME [EID E_AGE | E_SALARY |E_PHONENO|E_CITY AJAY C1 23 10000. 09854346511 [BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK c3 25 15000 (09834567888 | INDORE ASHA C4 25 10000 09811122766 | PUNE RITU C5 28 10000 09909234567 [BHOPAL SQL > SELECT * FROM EMPLOYEE ORDER BY E_SALARY ; OUTPUT: E.NAME EID E_AGE E_SALARY — E_PHONENO — E_CITY AJAY cr 2B 10000 (09854345511 BHOPAL, ASHA ca 28 10000 09811122766 PUNE RITU cs 28 10000 09909234567 BHOPAL PRATEEK C2024 12000 (09823453333, BHOPAL NAITIK «C325 15000 (09834567888 INDORE, 6. Apply the following aggregate function in the employee salary column of employee table ‘A)Sum B)Max —C) Min) Count E) AVG, E.NAME [EID |EAGE | SALARY |E_PHONENO|E CITY AJAY ct 23 10000 (09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NATIK | C3 25 15000 (09834567888 | INDORE ASHA C4 25 10000 (09811122766 | PUNE RITU [ord 28 10000 (09909234567 | BHOPAL SQL > SELECT SUM (E_SALARY) FROM EMPLOYEE: OUTPUT: SQL > E_SALARY 57000 SELECT MAX (E_SALARY) FROM EMPLOYEE;SQL > SELECT MAX (E_SALARY) FROM EMPLOYEE; OUTPUT: E_SALARY 15000 SQL > SELECT MIN(E_SALARY) FROM EMPLOYEE: OUTPUT:- E_SALARY 10000 SQL> SELECT AVG (E_ OUTPU’ SALARY) FROM EMPLOYEE; E_SALARY 11400 7. Write the query to delete those tuples from the Employee where employee city is Bhopal. E.NAME [EID E_AGE | SALARY |E _PHONENO |E CITY AJAY C1 23 10000 (09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK C3 25 15000 (09834567888 [INDORE ‘ASHA ca 25 10000 (09811122766 | PUNE RITU cs 28 10000 (09909234567 | BHOPAL SQL > DELETE * FROM EMPLOYEE WHERE E_CITY= ‘BHOPAL’ ;SQL > SELECT * FROM EMPLOYEE 3 E.NAME EID E_AGE ESALARY E_PHONENO — E_CITY C4 25 10000 00811122766 = PUNE a 25 15000 (09834567888 INDORE, 8 Write the query to Increase the employee salary by 5 percent in the Employee table where employee age is 25. E.NAME [EID E_AGE _[E_SALARY |E PHONENO |E_CITY AJAY C1 23 10000 09854345511 | BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK C3 25 15000 09834567888 | INDORE ‘ASHA C4 25 70000 09811122766 | PUNE RITU 5 28 10000 (09909234567 | BHOPAL SQL> UPDATE EMPLYOEE SET E_SALARY= E_SALARY+ E_SALARY*0.05 WHERE E_AGE = 25;OUTPUT:- SQL>SELECT * FROM EMPLOYEE; E.NAME EID E_AGE E_SALARY — E_PHONENO AJAY ca 23 10000 09854345511 PRATEEK C2 24 12000 09823453333 NAITIK, GC 25 15750 09834567888 ASHA C4 25 10500 09811122766 RITU cs, 8, 10000, 09909234567 E_CITY BHOPAL BHOPAL INDORE PUNE BHOPAL 9 Write the query to add a new column employee address in the Employee table where the type of new column is character and size is 25: E_NAME | E_ID E_AGE | E_SALARY |E_PHONENO |E_CITY AJAY. ct 23 10000 (09854345511 [BHOPAL PRATEEK | C2 24 12000 (09823453333 | BHOPAL NAITIK | C3 25 15000 09834567888 [INDORE ‘ASHA cA 25 10000 (09611122766 | PUNE RITU ce 28 10000 09909234567 [BHOPAL SQL > ALTER TABLE EMPLOYEE ADD E_ADD VARCHAR(I5);OUTPUT: - SQL> Dese EMPLOYEE ; Name E_NAME VARCHAR(20) EID VARCHAR(10) E_AGE NUMBER(10) E_SALARY NUMBER(10) E_PHONENO. NUMBER(10) E_ciTy VARCHAR(15) E_ADD VARCHAR(15) 10. Write the query to delete the table Employee E_NAME | EID E_AGE _|E SALARY |E_PHONENO |E CITY AJAY ct 23 410000 09854345511 | BHOPAL PRATEEK | C2 24 712000 (09823453333 | BHOPAL NAITIK, c3 25 15000, 09834567888 | INDORE ASHA ca 25 10000 09811122766 | PUNE RITU cS 28 10000 09909234567 | BHOPAL SQL>DELETE FROM EMPLOYEE ; TPU EMPLOYEE table would not have any record.