SQL Tutorials - Lab Exercises

SQL Tutorial: (Based on M.G. University - MSc Computer Science)

SQL Lab Practice - 2

Create the following tables

Table - I ( EMPLY )

Table - II ( PAYSLIP )

Write SQL commands for the following:

Update table EMPLY, add 15 years of age to employee with EMPCODE 'E107'.

Create a view which shows details of employees whose age is between 35 and 45.

Retrieve empcode, empname, address, Netpay from EMPLY and PAYSLIP. Display in ascending order of empcode.

Create an English like sentence to display the following output from payslip table. "Employees with empcode E101 draws a basic salary 4000".

List the names and address of employees drawing a basic salary between 5000 and 7000.

Add new column Total_Sal in the PAYSLIP table and display all details including total salary for Employees with Empcode > E107.