Question: Use the 17 Classic Cars Data mah database Create a query to select any record with coupe in the model name Include the

Use the 17 Classic Cars Data mah database 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 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 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
