The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information:

• Car ID
• Month
• Day
• Count

You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team.

Task

Query the frequency of each car's use by month and day 

The Driver Relationship team wants to analyze drivers and their car usages in InstantRide for the month October. Thus, they want to focus on each driver and respective car allocation occurred. In more detail, the team requires the DRIVER_ID and the CAR_ID with their usage counts as the TOTAL column for the travels occurred in the month of October. Since the team wants to also learn the total number of the travels by the drivers you need to use GROUP BY ROLLUP functionality.

Task

Create a query to analyze car usage for the month of October.

As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more.

You need to send the number of travels calculated for each day and month with their totals using Month, Day and Count column names. Furthermore, you can name your subquery as PREMIUM_RIDES to work only with the travels with the price of 5 or higher.

Task

Calculate the number of premium rides given for each day and month.