Question: 1) SQL statement to display the average cost of a Chevy rental. SELECT AVG (Daily_Cost) FROM Car_Rental WHERE Make = 'Chrys'; True False 2) SQL
1) SQL statement to display the average cost of a Chevy rental. SELECT AVG (Daily_Cost) FROM Car_Rental WHERE Make = 'Chrys';
| True | |
| False |
2) SQL statement to display the lowest-priced vehicle. SELECT Car_Rental.Size, Car_Rental.Make, Car_Rental.Model, Car_Rental.Daily_Cost FROM Car_Rental WHERE Daily_Cost = DMax("Daily_Cost", "Car_Rental");
| True | |
| False |
3) SQL statement to display each agency only once: SELECT DISTINCT Agency FROM Car_Rental;
| True | |
| False |
4) SQL statement to display the total count of cars available: COUNT FROM Car_Rental;
| True | |
| False |
5) SQL statement to display each unique agency with the average car price for that agency. SELECT DISTINCT agency, AVG (Daily_Cost) FROM Car_Rental GROUP BY agency
| True | |
| False |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
