Write SQL query

Question 1 For this question please use the following table structures to answer each part of the question. Table Structure: Locations Employees Element Name Data Type Element Name Data Type ID autoNum ID autoNum location OID number locationOID number civic Address number first Name string city string lastName string province string location number version Number number version Number number Example Data: Employees ID employeeld firstName lastName locationOID version Number 1 12345 Melanie Ersla 1 1 2 54321 John McDonald 2 1 3 98765 Luigi Preston 4 1 4 12345 Melanie Smith 2. 2 5 98765 Luigi Preston 2 2 Locations ID location OID civicAddress city province version Number 1 1 123firstst Ottawa Ontario 1 2 2 Oshawa Ontario 1 255 Albert St. 3 3 1 123 First St. Ottawa Ontario 2 4 4 Gatineau Quebec 1 98 Rue Alexandre 5 2 Ottawa Ontario 2 255 Albert St. Part A Write an SQL query that would display the latest information for each employee Part B Write an SQL query that would display the latest employee information for all employees that work in Ontario. Part C Write an SQL query that would display the latest information for each employee, including their work civic address, city, and province