Q4. Let's explore the data through new queries. a) Write a query that shows what the average MSRP is. SELECT FROM TIP: Use the functions within the SELECT statement for this. You can see a summary of the available functions at the end of page 8. b) Write a query that shows what the average MSRP is by product Line (the result should show 1 column with product line, and 1 with average MSRP). SELECT FROM GROUP BY c) Write a query that shows what the average buxPrice is per product Line (the result should show 1 column with product line, and 1 with average buyPrice). Add aliases to the columns to better present the output. MySQL Sample Database Diagram productlines productline textDescription htmlDescription mage orderdetails order Number product Code quantityOrdered priceEach orderlineNumber O HH products In product Code productName productLine productScale product Vendor product Description quantityInStock buy Price MSRP CH employees amployooNumber ENSIName firstName EXION email omnicecode MoportsTo JobTIK customers orders orderNumber order Date requiredDate shippodDate status comments customerNumber + customer Number customerName contactLastName contactFirstName phone addressLine1 addressLine2 city Slalle postalCode country salesRepEmployee Number creditLimit HT offices officecode city Phone addressLine1 Oddressline 2 state Country posta code cenom et payments customer Number checkNumber payment Date amount