Need some help understanding this . Please provide details 3. Scale Classic Cars

Question

Need some help understanding this . Please provide details

3. Scale Classic Cars Johnny Krol runs a body shop that specializes in restoring classic cars. Johnny owns three classics and began collecting scale models when his wife put her foot down and said no to building more garage space for his cars. Although Johnny frequently used the Internet and e-mail, he had never considered start ing an e-business. The Scale Classics Web site began as a technology class project for Johnny's son J.J., who created a basic text and graphics informational site. Johnny liked the site, but wanted a complex site dedicated to the serious collector. He envisioned a store- front, auction house, and collector's forums and had been unable to find such a site in his online searches. Johnny hired a local consultant to build the site, found a processing house to manage orders and payments, and began shipping scale models from the body shop The storefront is largely for American classic cars, which come in 1/18, 1/24, 1/43, and 1/64 scale. Popular foreign cars are also available. Johnny has hired you to create some business analysis queries, specifically he wants you to 1. Use the T7 ClassicCars Data.mdb database 2. Create a query to select any record with "coupe" in the model name. Include the Make and Model in the query. Save the query as Coupe Query 3. Create a query to select the models that cost less than $35. The query should display the Car ID, Make, Model, and Price fields and sort the result from the highest to the lowest price. Save the query as Less Than $35 Query 4. Create a query listing classic cars grouped by their make. The query should display only the Make, Model, and Price fields. Sort by the model and calculate the average price for each make. Save the query as Cars By Model Query

Explanation / Answer

1. Coupe Query

Select Make,Model from Catalog where Model like '%Coupe%' ;

here Make and Model of cars from Catalog table are selected and the in condition where , Like operator is used to match the Model name having word 'Coupe'.

2. Less than $35 Query

Select CarID,Make,Model,Price from Catalog where Price < 35 order by Price desc;

Here columns are selected from Catalog table where Price is less than 35 from Highest to lowest Price so order by descending is used

3. Cars By Model Query

Select Make,Model,AVG(Price) from Catalog group by Make order by Model;

here columns Make,Model and AVG(Price) is selected by grouping Make , So Average price of all cars of one make are computed and order by is used to show result in ascending order of Model name.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.