FOR FREE MATERIALS

Basic SQL assignment with solution and proper description:

Schema or Relation or Table:

Employee (EMPNO, ENAME, JOB, DEPTNO, SAL)

Queries:

a) Modify the column width of the job field.

b) Update the Employee table to set the salary of all employees to Rs. 15000 who are working as ASP.

c) Delete only those who are working as lecturer.

d) List the records in the Employee table order by salary in ascending order.

e) Display the names of those whose salary is in between 15000 to 30000.

f) Display the names of those whose salary is not between 15000 to 30000.