Task $1$:

The InstantRide Driver Relationship team wants the details of the drivers and the number of cars they use. Calculate the count of the CAR$\_$ID field in the TRAVELS table and return a table grouped by DRIVER$\_$ID and in descending order by the calculated COUNT column, displayed as CARS

Task $1$: Calculate the number of cars each driver uses.

Test Feedback:

Status: FAILED!

Check: $1$

Test: Calculate the number of cars each driver uses

Reason: The following error is preventing tests from completing: $1146(42$S$02)$: Table 'InstantRide.TRAVELS' doesn't exist

Error : ProgrammingError $-1146(42$S$02)$: Table 'InstantRide.TRAVELS' doesn't exist

Timestamp: $2024-05-0321$:$20$:$33\mathrm{.}239228$

Task $2$:

The InstantRide Driver Relationship team requires the detail of the drivers who has used more than one car for rides more than twice. Send them the DRIVER$\_$ID with the calculated COUNT of used cars, displayed as CARS in decreasing order.

Task $2$: Query the drivers that have used more than one car more than once.

Task $3$:

The InstantRide Marketing team is planning to create a heatmap of the start locations of the travels in InstantRide. The team requires the DISTINCT TRAVEL$\_$START$\_$LOCATION values for all travels in the system.

Task $3$: Query all the distinct start locations.

Task $4$:

The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL$\_$ID count to the three mathematical functions.

Task $4$: Query the average, maximum, and total number of rides users have taken.

Task $5$:

The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER$\_$ID and two calculated columns: DAY and RIDES.The DAY column is calculated using the DAY$()$ function with the TRAVEL$\_$START$\_$TIME as the argument. The RIDES column is calculated by using the COUNT$()$ function to determine the number of rides given for each day. Filter the results with the MONTH function.

Task $5$: Query all travels given by drivers in the month of October.

Task $6$:

The InstantRide User Satisfaction team received a phone call from a user who might have left her wallet in the car. She indicated that the license plate of the car was starting with BB$-883$ but unfortunately, she could not remember the full license plate number. The team wants to get all travel information for the cars with the license plate starting with BB$-883$ You need to return all travel data from the TRAVELS table for the CAR$\_$ID which has a plate number compared with SUBSTR and UPPER functions.