A Company called Wetu decided to computerize its employee data. The company has four departments $($Management$,$ Marketing, Accounting and Purchasing$),$ each headed by a boss. One of the tables called EMPLOYEE is as given below:

You are required to give:

An SQL statement that creates the database called Wetu

An SQL statement that creates the above table $($Employee$)$

An SQL statement for adding the first five records into the table

Retrieve all columns, all rows from the table

An SQL query that shows the average salary for employees

An SQL query that displays the following columns: PFNO, E$-$Name and D$\_$Name

An SQL query that gives the number of employees that reports to Boss $1$

Report the details of employees grouped by department and sorted by personal file number

An SQL query that displays all staff with salaries between $30,000$ and $50,000$

Due to improved economy, employee salaries have been increased by $15\%.$ Write an SQL statement to effect the change$\backslash$table$[[$PFNO$,$E Name,E Salary,D Mame,Boss$],[7001,$Alice,$75,000,$Nanagement,$5],[7002,$Ned,$45,000,$Narketing,$1],[7003,$Andrew,$25,000,$Narketing,$2],[7004,$Clare,$22,000,$Accounting,$2],[7005,$Todd,$38,000,$Accounting,$1],[7006,$Karival,$22,000,$Marketing,$5],[7007,$Robert,$43,000,$Purchasing,$1],[7008,$Sarah,$56,000,$Purchasing,$7],[7009,$Sophie,$35,000,$Personnel,$1]]$