Q1. Write the SQL statement to display the ids, names, job names and salaries of all employees in descending order by minimum salary.

Q2. Write the SQL statement to insert a new column named “head_of_dept” in department table after the “dept_name” column and insert the following names in it. (James Hoog, Nail Knite, Pit Alex, Paul Adam, Lauson Hen, Julian Green, Brad Davis, Fabian Jhonson, Geoff Cameron, Nick Altidor).

Q3. Rename the following columns: 

•  “job_name” to “designation” in “Employee” 
•  “dept_id” to “department_id” in “Department” 
•  “postal_code” to “zip_code” in “Location”.