kindly answer only the questions marked in blue ink .The question is base d in mysql 10:3125Q.2 Write a query in MYSQL to doi) Display structure of the table.ii) Display all the recordsii) Change name of the column DEPARTMENT_ID to DPT_ID and name of thecolumn last_name to l_name. Check the new titles.iv) Delete the details of employee whose id is 143. Check the change.Change MANAGER_ID of an employee whose last name is Higgins, to 124.vi) Display distinct JOB_IDvii) Display the last name and salary for all employees whose salary is not in therange of 5000 and 12000.viii) Change name of the column hire date to startdate. Check the change.ix) Display the last name, job ID and start date of employees hired betweenFebruary 20,1999 and May 31,1999. Order the query result in ascendingorder by start date.Display first name and startdate of every employee who was hired in 1994.xi) Display the last name and job title of all employees who do not havemanager.xii) Display the last name of all employees who have an 'a' and an 'e'in their lastname.xiii) Display the last name of all employees who have an 'a' or 'e' in their lastname. Sort the records in alphabetical orders of last name.kinCreate a new column commission and enter commission as 20% for Eleni andJonathan and as 15% for Kimberely.xv) For each employee, display the employee number, last name, salary andsalary increased by 15%. Label the column as New salary.xvi) Create a query that displays the employee's last name and salary. Sort thedate in descending of salary. MYSQL-2Sem - VB.Sc.Practical No.2a) Create a table with the following columns. (Give name of yourchoice)Name of employee ( NAME, variable character)Date of birth (DOB, date).Salary of employee (SALARY, integer).Department (DEPT ,variable character).[Department: SALE, ACCT, MARKETING]Enter at least 10 records.b) Give SQL queries for the followingGive details of all employees in the company.(i)(ii)List names of employees along with their salaries.(iii)(iv)Give details of employees from SALE department.Give details of employees with salary between 5000 and10000.(v)Add two more records.(vi)Give name, date of birth and salary of employees withdepartment ACCT and salary more than 20000.List the names & date of birth of employee whose name(vi)starts with 'B'.List names of all employees whose salary is greater thanDisplay the names of distinct departments.List names of all the employees with first threecharacters unknown and ending with NI.Display name, department and date of birth of those employeeswhose date of birth is before a particular date.(vii)30000.(ix)(x)xi)Create a database in your name and do the following.1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int),(Salary dec(9,2)),(D_birth date). Enter 10 records.Display all rows.Insert a new column place(varchar)Supply values for the newly added column and Display all rows.Display Sum, maximum, minimum and average values of salary.Delete rows where place contains the letter 'M' and display theremaining rows.Delete the table MyFriend from the database.(i)(ii)(iv)(vi)

The ask it to build the query for the various scenarios given above. For the first question, table…

xi) Display name, department and date of birth of those employees whose date of birth is before a particular date. Create a database in your name and do the following. 1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int), (Salary dec(9,2)),(D_birth date). Enter 10 records. (i) Display all rows. (ii) Insert a new column place(varchar) Supply values for the newly added column and Display all rows. Display Sum, maximum, minimum and average values of salary. Delete rows where place contains the letter 'M' and display the remaining rows. (iv)