Asked by:

psha85
Rating : No Rating
Questions Asked: 27
Tutorials Posted: 1, earned $4.09

 

$3.00 MySQL database

• From Computer-Science: General-CS
• Closed, but you can still post tutorials
• Due on Apr. 19, 2009
• Asked on Apr 18, 2009 at 7:05:31PM

Q:

Please help me in solving this MySQL problem. I'm not sure how to create this and which program to create it in. If someone can show me how to do this problem and tell me what I use to code it then I will be forever grateful. Thanks a ton!!!

Problem:

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

Create a SQL file for each query.

 

Attachments: