Note: This is a single question so please answer all parts of the questions; I would greatly appreciate it, thank you very much!

In the input field below, write an SQL query that lists the vendor name, machine model, date purchased, and the anticipated year of the next required purchase. List in order by future purchase year. (HINT: Future purchase year can be calculated by taking the year of a machine's purchase date and adding the expected machine's years of life. (Year([Machine].[DatePurchased]))+[Machine].[MachExpectedYears]) ) In the input field below, write an SQL query that lists the total cost to the company of all the unscheduled maintenance performed in 2018. In the input field below, write an SQL query that lists by machine, the machine id and purpose for machines that have experienced more than 2 unscheduled maintenances