Please show step by step process with pictures and detail 3. Scale Classic Cars
ID: 3815281 • Letter: P
Question
Please show step by step process with pictures and detail
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 Johnnys son J.J., who created abasic 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 TT 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
Coupe Query:
Select Make,Model from CATALOG WHERE Model LIKE '%coupe%';
Less than 35$ Query:
Select Car as Car ID, Make, Model, Price from CATALOG WHERE Price<35 ORDER BY Price Desc;
CARS By Model Query:
Select Make, Model, Avg(Price) as Avgprice from CATALOG GROUP BY Make ORDER BY Model