SQL Queries

  1. Create a table EMPLOYEE having fields/columns/attributes: empid,ename,mobile , basicSal,da, hra, ma ,total,tax, net
  2. insert 6 records having empid,ename,mobile and basicSal.
  3. Now Calcuate DA @50% on basicSal for all employees
  4. Now Calcuate ma @30%, hra @20% on basic sal for all employees
  5. find out total annual salary (12 Months)
  6. Calculate tax @ 10% if total salary is less than 5lac else tax should be 20%
  7. find the net salary of all employees
  8. show all records
  9. show all records in asceding order by name.
  10. find out avg salary of all employees
  11. show record of the employee got highest total salary