(Solved): Sort cars in the tCAR table into the following categories based on mileage: Less than 0 to 100 - No ...

Sort cars in the tCAR table into the following categories based on mileage: Less than 0 to 100 - No Miles Between 10 and 100 - Very Low Miles Between 100 and 20,000 - Low Miles Over 20,000 - High Miles Next, sort the cars by price based on the following: Over 100,000 - Very Expensive Between 50,000 and 100,000 - Expensive Between 20,000 and 50,000 - Moderately Expensive Between 10,000 and 20,000 - Affordable Less than 10,000 - Cheap The columns in tCar are CarID, Description, Condition, Price(0 to 45,000.00) Mileage (from 0 to 500,000), MileageCategory(No miles, high miles, low miles) and PriceRange(expensive, cheap, moderately expensive).