Help me in sql question
Rank from highest to lowest the best sellers of Race bikes in 2011. Hint - Use a subquery to calculate the total sales of Race bikes as a denominator. Multiple the formula above by 100.0 to get percent.
Customer Bicycle Mode Type TubeMaterial BikeTubes ModelType Description Componenti Bicycle Tubesae SerialNumber TubeID Quantity Customer Phone First Name LastName Gender Address ZIP Code City ID Balance Due SerialNumber Tube Name TubeID Length Groupo Component GroupID GroupName BikeType Year End Year Weight Paint Tube Material Description Diameter Thickness Roundness Weight Stiffness List Price Construction Active PaintID ColorName ColorStyle Colorist Date introduced DateDiscontinued ModelType Model Type Msize Top Tube ChainStay TotalLength Ground Clearance Head TubeAngle Seat Tube Angle SerialNumber Customer ModelType Painti FrameSize OrderDate StartDate ShipDate ShipEmployee FrameAssembler Painter Construction Water BottleBreOn CustomerName LetterStyle StorelD Employee Top Tube Chain Stay HeadTubeAngle SeatTube Angle List Price Sale Price SalesTax Sale State Ship Price FramePrice ComponentList Bike Parts Customer Trans LetterStyle SerialNumber Component ID SubstituteID Location Quantity Datenstalled Employee GroupComponent LetterStyle Description Component Component ID Manufacturer Product Number Road Category Length Height Width Weight Year End Year Description ListPrice Estimated cost QuantityOn Hand Customer TransactionDate Employee Amount Description Reference GroupID Componenti Retail Store Purchase Order Purchase tem StoreID StoreName Phone ContactFirst Name ContactLastName Address ZIP Code CityID Employee Employee ID Taxpayer ID LastName First Name Home Phone Address ZIP Code City Date Hired Date Released Current Manager Salary Grade Salary Title Work Area Purchase Employee Manufacturer Totallist Shipping Cost Discount Order Date ReceiveDate Amount Due Purchase Component ID PricePaid Quantity Quantity Received Component Name Component Name AssemblyOrder Description State Tax Rate Manufacturer Manufacturer Trans State Twe City CityID ZIP Code City State Area Code Population 2000 Population 1990 Population 1980 Country Latitude Longitude SelectionCDF FIPS Income 2004 Division StateCode MSACMSA MASC CMSA amore> Work Area WorkArea Description Manufacturer Manufacturer Name Contact Name Phone Address ZIP Code City ID BalanceDue Manufacturer TransactionDate EmployeeID Amount Description Reference Customer Bicycle Mode Type TubeMaterial BikeTubes ModelType Description Componenti Bicycle Tubesae SerialNumber TubeID Quantity Customer Phone First Name LastName Gender Address ZIP Code City ID Balance Due SerialNumber Tube Name TubeID Length Groupo Component GroupID GroupName BikeType Year End Year Weight Paint Tube Material Description Diameter Thickness Roundness Weight Stiffness List Price Construction Active PaintID ColorName ColorStyle Colorist Date introduced DateDiscontinued ModelType Model Type Msize Top Tube ChainStay TotalLength Ground Clearance Head TubeAngle Seat Tube Angle SerialNumber Customer ModelType Painti FrameSize OrderDate StartDate ShipDate ShipEmployee FrameAssembler Painter Construction Water BottleBreOn CustomerName LetterStyle StorelD Employee Top Tube Chain Stay HeadTubeAngle SeatTube Angle List Price Sale Price SalesTax Sale State Ship Price FramePrice ComponentList Bike Parts Customer Trans LetterStyle SerialNumber Component ID SubstituteID Location Quantity Datenstalled Employee GroupComponent LetterStyle Description Component Component ID Manufacturer Product Number Road Category Length Height Width Weight Year End Year Description ListPrice Estimated cost QuantityOn Hand Customer TransactionDate Employee Amount Description Reference GroupID Componenti Retail Store Purchase Order Purchase tem StoreID StoreName Phone ContactFirst Name ContactLastName Address ZIP Code CityID Employee Employee ID Taxpayer ID LastName First Name Home Phone Address ZIP Code City Date Hired Date Released Current Manager Salary Grade Salary Title Work Area Purchase Employee Manufacturer Totallist Shipping Cost Discount Order Date ReceiveDate Amount Due Purchase Component ID PricePaid Quantity Quantity Received Component Name Component Name AssemblyOrder Description State Tax Rate Manufacturer Manufacturer Trans State Twe City CityID ZIP Code City State Area Code Population 2000 Population 1990 Population 1980 Country Latitude Longitude SelectionCDF FIPS Income 2004 Division StateCode MSACMSA MASC CMSA amore> Work Area WorkArea Description Manufacturer Manufacturer Name Contact Name Phone Address ZIP Code City ID BalanceDue Manufacturer TransactionDate EmployeeID Amount Description Reference
