List names of all the employees who are located in Toronto. 2. List…

Question Answered step-by-step List names of all the employees who are located in Toronto. 2. List… List names of all the employees who are located in Toronto. 2. List the first name, Department name, salary and hire date of the three longestserving employee from the Shipping department. (3. List all employees who last name starts with F and are not located at the location ID1700. 4. List the name and hire date for all the employees who have been hired in 2022 andwork at Oxford office. ( 5. List the employee id, name, salary, of all the Accountants, their average salary, andthe difference between the salary of each employee and the average salary. Thesample of the part of the output is as follows: 6. List department id and name of all the departments which are in Europe and have amanager. 7. Display the explain plan for Query # 6. What can you do to make it better explain withthe help of new plan? (5 Marks) 8. Create a view named empcount_view to display the location id, department id andcount of employees in each department which has 4 or more employees. Write theSQL command to display the records in the view. (8 Marks) Computer Science Engineering & Technology MYSQL IT 145 Share QuestionEmailCopy link Comments (0)