consider the database below and answer the query. pk refers to primary key and FK refers to foreign key.    Employee(Employee_id(PK), First_name, Last_name, Email, Phone_number, Hire_Date, Job_ID(FK) COmmision_pct, manager_id, department_id(FK))   Departments(Department_id(PK), dept_name, manager_id(FK), location_id)   Locations(Location_id(PK), street_address, postal_code, city,

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.   ANSWER IN MYSQL PLEASE

Question 2 and 3

SQL Queries:   Given the following schema. Primary keys are underlined and highlighted in yellow and foreign keys are bold. The meaning of the relations is straightforward. Medical_Staff(MS_Id, MS_First, MS_Last, MS_PhoneNumber, MS_Occupation, Salary) Blood_Bank(Bank_Id, Bank_Name, Bank_Street, Bank_City, Bank_St, Bank_PhoneNumber) Donor(Donor_Id, Donor_First, Donor_Last, Donor_BloodType, Donor_City, Donor_St, DOB, TotalNumberOfDonations) Donation_Record(Donor_Id, Donation_Date, Donation_Amount) Employee(MS_Id, Bank_Id) Storage(Donor_Id, Donation_Date, Bank_Id)   Write SQL queries to answer the following questions:   a.Find the average donation amount for Sue Thompson (Donor Id = 3329) for the year 2018.                   b.Sum all donations by Bank for each State (i.e. the State the blood bank is located in, not the Donor).                     c.Find the name of the youngest donor and all the donations made in by that donor in 2020.