Car Dealership SQL

Create a database for a used car dealership that includes a table for inventory. Include the following fields in the inventory table: make, model, price, and mpg (miles per gallon). Enter at least 10 records into the table. Write queries that return the following:

  • All Records
  • Make, model, and price, sorted by make and model
  • The make and model of the car that gets the best miles per gallon
  • The make and model of the car that gets the worst miles per gallon
  • The make and model of the highest and lowest priced cars
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.