Normal 1No Spac.. Heading1 Heading 2 Heading 4 Title Subtitle Subtle Em.... Emphasis Intense E...Stron Styles Consider the following relational schema. An employee can work in more than one department, also, the percentTime field of the Works relations shows the percentage of time that a given employee works in a given department EmploxscsclD integer, Name string, Name string, age integer, salary real) Losations(UD integer, address string, city string, state string, zip string) Departments(dIlD integer, dName string, budget real, managerEID integer, locationlD integer) Worksin(elD integer, dID integer, percentTime integer, startDate date, endDate date) The primary key fields are underlined, and the domain of each field is listed after the field name. Thus eID is the key for Employees, ID is the key for Locations, diD is the key for Departments, and elD and dID together form the key for WorksIn. These tables have been created and the data have been populated using MySQL server Download HW1sql to your computer and run it on MySQL. Execute your SOL statements based on these tables. Turn in your SQL queries statements and the results of these queries to the assignment link Write the following queries in SQL statements. The query answers must not contain duplicates, but you should use the SQL keyword DISTINCT only when necessary When your SQL query statement is not accepted by MySQL, it will display error messages. You need to read that message and fix all problems accordingly. Note that MySQL does not support "INTERSECT and EXCEPT" currently. When you need to find the intersection and difference of two result sets, you can use "IN" and "NOT IN instead. In addition, for this i.e, for each question you must write exactly one SQL statement. assignment, creation of temporary tables is not allowed 1. (20 Points) Find the minimum, maximum, and average salary in each Answer (20 Points) Retrieve the name and salary of the two highest salaried employees for the department Research. Answer: 2. 3. (20 Points) Retrieve the name of employees, whose salary is higher than the average of all employees, and their department name