Q1: List the customers from California who bought red mountain bikes in 2003

Q2: List road bicycle sale prices which are greater than the average sale price sold in 2011. List these bikes with the most expensive on the top

Q3: Which cities in California do not have retail stores in them.

Q4: Which customer(s) purchased the most number of bicycles in a single month. Hint - Use the format function: format(orderdate, 'yyyy-MM') to group sales into a single month value.

Q5: 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.

Q6: 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 Bicycle Tube Material BikeTubes Model Type ModelType Description Componenti Bicycle TubeUsae SerialNumber TubeID Quantity Groupo SerialNumber Tube Name TubeID Length Customer Phone First Name LastName Gender Address ZIP Code City ID BalanceDue ModelType Component GroupID GroupName BikeType Year End Year Weight Paint Tube Material Description Diameter Thickness Roundness Weight Stiffness List Price Construction IsActive PaintID ColorName ColorStyle Colorlist Date Introduced Date Discontinued Model Type Msize Top Tube ChainStay Totallength Ground Clearance Head TubeAngle SeatTube Angle Bike Parts SerialNumber Customerid ModelType Paintin FrameSize OrderDate StartDate ShipDate ShipEmployee FrameAssembler Painter Construction WaterBottleBrazeOn CustomerName LetterStyle StorelD Employee ID Top Tube ChainStay HeadTubeAngle SeatTube Angle List Price Sale Price SalesTax SaleState Ship Price FramePrice ComponentList Component CustomerTrans LetterStyle LetterStyleID Description SerialNumber Component ID SubstituteID Location Quantity Datel nstalled Employeel D Group Component GroupID Component ID Customer Transaction Date Employee ID Amount Description Reference Component ID Manufacturerid Product Number Road Category Length Height Width Weight Year End Year Description ListPrice Estimated Cost QuantityOn Hand Employee RetailStore PurchaseOrder Purchaseltem StorelD StoreName Phone ContactFirstName ContactLastName Address ZIP Code CityID EmployeeID Taxpayer ID LastName FirstName Home Phone Address ZIP Code CityID Date Hired Date Released Current Manager Salary Grade Salary Title Work Area PurchaseID Employee ID Manufacturer TotalList Shipping Cost Discount Order Date ReceiveDate Amount Due PurchaseID Component ID PricePaid Quantity Quantity Received Component Name Component Name AssemblyOrder Description State Tax Rate Manufacturer Manufacturer Trans State T Rate City CityID ZIP Code City State Area Code Population 2000 Population 1990 Population 1980 Country Latitude Longitude SelectionCDF FIPS Income 2004 Division State Code MSACMSA MASC CMSA > Work Area WorkArea Description Manufacturer Manufacturer Name Contact Name Phone Address ZIP Code City ID Balance Due Manufacturer ID Transaction Date EmployeeID Amount Description Reference