Can someone help?Thank you in advance 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. Scenario and Database Model: InstantRideInstantRide is the new ride sharing application in the city and it has just started its operations.With the help of the InstantRide mobile application, the users request a ride with their location.Drivers and cars are assigned to the request; and then the driver picks up the user to ride theirrequested location. Information for the users, drivers and cars are stored in the database as well asthe travel transactions.In the USERS table, information for the users are stored with their first name, last name and email:USER_ID30013002300330043005300630073008USERS Table200120022003USER_FIRST_NAME2004JackRyanNursinSarahDRIVERS TableBobbyRandyJoseNursinHowardIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving licensenumber and check and rating information:WalkerDRIVER ID DRIVER FIRST NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START_DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATINGWillieButler18745012019-09-12JustinAnthonyEceYilmaz1953853USER_LAST_NAME1735487HillCollinsYilmaz1734747PriceGriffinClarkThomasYilmaz2019-09-092019-09-152019-08-151USER_EMAILj.hill@xmail.com1r.collins@xmail.comn.atak@gmail.coms.price@xmail.comb.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comn.yilmaz@xmail.com1444.83.50 In the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR ID1001100210031004CARS TableTRAVEL ID5002500350045005500750085010TRAVEL START TIME2016-10-01 00:04:552015-10-01 05:57:352015-10-01 13:36:202015-10-02 08442015-10-02 12015-10-05 19:12:142015-10-03 16:06:362015-10-03 17:17:122015-10-05 21:16:482015-10-03 23:21:40CAR PLATETRAVELS TableBB-542-ABBB-883-EEBB-451-ZN88-189-MMFinally, the transactions of the rides are stored in the TRAVELS table. For each travel, start andend time with location are stored. In addition, the involved driver, car and user are listed for eachdrive. Price and discount information are also available in the database:TRAVEL END TIME2010-10-01 04:14:192015-10-01 08:12:352019-10-01 13:15:102015-10-07 01:15:282015-10-42 16:48:02015-10-01 19:25:42019-10-03 16:38:562019-10-03 17:37:422019-10-03 21:26:182019-10-03 23:39:10TRAVEL START LOCATION0554 York Fond47 Church Street>Wiad2050 MilaneCAR MODEL50 M39 Road37 The Drive77 Mill Road16 Church RoadTOYOTA PRIUSTESLA MODEL 3TOYOTA AURISMERCEDES E200TRAVEL END LOCATIONChurch Lane95 W27 Main Roadaway91 West Str17 Stanley Road724 Springfield Road30 North RoadTRAVEL PRICE15,4420.5613.3216,4911.1514.614.4125.1225.62DRIVER ID330120022001200520002001CAR YEAR20182009201920192019CAR ID100510021004100310091002USER ID300030023001300710073008300130053003TRAVEL DISCOUNTNULLMALMEL0.15NUEL0.100140.25MALL0.20You are assigned as the database administrator to collect and manage transactional data of theInstantRide operations. Your main task is to create SQL scripts to help other teams to retrieve therequested data. In the following activities, you will create the scripts, run against the database andsend the result to the corresponding teams.

DAY(DATE) returns day number in dd format example 25 MONTH(DATE) returns month number in mm format,…

Answered: The InstantRide Driver Relationship…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE