Picture 6.1
Question 7:
Write a query to display, for each of the three locations named 'Downtown Office', 'NorthsideBranch', and 'Airport Terminal', the number of cars of each category currently located at each location. Display the results with RentalLocationID, LocationName, CategoryID,CategoryName, NumberOfCars in descending order of LocationName, then in ascending order of CategoryName for rows with the same LocationName. Note that if there are no cars of a particular category currently located at a location, the NumberOfCars for those rows must be 0, as shown in the following figure:
Zoom
+ 100%
Close
