I need help on this database SQL questions refer to the table given. Thank you

1. Compare the average sale price of race bikes in 2006 based on the type of down tube(e.g., Carbon, Aluminum, Titanium, or Cro-moly). Hint Use TubeMaterial table with link back to bicycle.

2. Using a UNION query, list the employees who painted bicycles on March 15, 2012 or framed them on that date (StartDate) (or both). Hint There are two columns on the bicycle table which are FK back to employee Painter and FrameAssembler. The Painter column in the bicycle table which represents the employee ID that did the painting. The FrameAssembler would be the employee ID of the framer.

Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCode Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCode