Scribd
Upload
2 views1 page

Employees SQL Assignment Questions

The document outlines an SQL assignment involving the creation and manipulation of an 'employees' table. It includes tasks such as retrieving employee names, adjusting salaries, deleting records based on age, and modifying the table structure. Specific SQL commands are provided for each assignment question to guide the implementation.

Uploaded by

rahulpanula
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Employees SQL Assignment Questions

The document outlines an SQL assignment involving the creation and manipulation of an 'employees' table. It includes tasks such as retrieving employee names, adjusting salaries, deleting records based on age, and modifying the table structure. Specific SQL commands are provided for each assignment question to guide the implementation.

Uploaded by

rahulpanula
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Employees SQL Assignment

DROP TABLE IF EXISTS employees;

CREATE TABLE employees (


employee_id SERIAL PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
department VARCHAR(50),
salary DECIMAL(10,2),
joining_date DATE,
age INT
);

Assignment Questions:
1. Retrieve all employees’ first_name and departments.
2. Increase IT salary by 10%.
3. Delete employees older than 34.
4. Add email column.
5. Rename department to dept_name.
6. Employees joined after 2021-01-01.
7. Change salary to INTEGER.
8. Order by salary DESC.
9. Insert Raj Singh record.
10. Increase age by 1.

You might also like