See the below tables and solve the given queries.

Table: Employee

 

 

Table: Incentives

 

 

Questions

1. Write queries to create table as given.
2. Write query to add a column to department table.
3. Write query to rename a column in department table.
4. Change datatype of a column in department table.
5. Delete a column from department table.
6. Write query to describe employee table.
7. Write query to rename department table to dept.
8. Write query to rename employee table to emp.
9. Write query to truncate employee table.
10. Write query to delete department table.

Note:

1. Upload screenshots containing query and its output in either jpg or png format.
2. Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
3. Optional questions are not required to submit.