CarlD Maker
Model
Year LicensePlate Status
RentalLocationID
LocationName
1
1
Toyota Nissan Altima
Camry
2020 ABC1234
Available 16
Waterfront
2
10
2022
BCD7890
Available 16
Waterfront
3
19
Hyundai Sonata
2018 ABC4567
Available 10
Central Park
4
22
Honda Pilot 2019 JKL6789
Available 16
Waterfront
5 52
Honda
Odyssey 2021
RST7890
Available 16
Waterfront
6
65
BMW i3
2019 JKL7890
Available 10
Central Park
Picture 3.1
Question 4:
Write a query to display RentalID, RentalDate, CustomerID, FirstName, LastName, CarID,Maker, Model, LicensePlate, CategoryName for all rentals with a RentalDate in 2021 where a car of the category named 'Standard' was rented. Display the result in ascending order of RentalDate as follows:
RentallD
Rental Date
CustomerID FirstName
LastName
CarlD Maker
1
153
2021-01-10 38
Mia
Long Young 51
87
Mercedes
Model
SLC
LicensePlate
CategoryName
VWX5678 Standard OPQ3456 Standard
2
26
2021-01-16 23
Lucas
Toyota Sienna
3 164
2021-03-20 48
Ella
Kelly
34
Chevrolet Equinox
RST5778 Standard
4
235
2021-03-26 61
James
Wright 28 Morris 78
Volkswagen Atlas Volkswagen Tiguan R
BCD1235 Standard
5 9
2021-04-19 92
Evelyn
UVW9012
Standard
6 19
2021-06-02 96
Harper
Hughes 28 Reed
Volkswagen Atlas Nissan
BCD1235
Standard
7
7
2021-06-03 71
Henry
100
Rogue Hybrid GHI6789 Rogue Hybrid GHI6789
Standard
8 10
2021-06-16 97
Aiden
Collins
100 Nissan
Standard
9 209
2021-09-01 58
Ava
Walker Johnson 28
100 Nissan
Rogue Hybrid GHI6789
Standard
10 14
2021-10-19 101
Alice
Volkswagen Atlas
BCD1235 Standard
Picture 4.1
Zoom
Question 5:
Write a query to display CategoryID, CategoryName, NumberOfRentals for each category,where NumberOfRentals is defined as the number of rentals with RentalDate from January 1. 2019. to March 31. 2019. of each category. Ensure that all categories are included in the
+ 100%
Close
