Help me in sql question

How many bicycles have we sold by model type and general price category? Use the following labeling scheme to rank the sales price:

• SalePrice
• SalePrice > 1001 and SalePrice
• SalePrice > 2501 and SalePrice
• SalePrice > 4001 and SalePrice
• SalePrice > 5500 = '(5) Very Expensive'

Display the number of bikes in each category by model type. Hint - Use a case statement. Also specify the ranking text as above to allow for sorting. Sort by model type and then price.

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