Can someone help?Thank you in advance 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. 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.

Derived Table : SELECT USER_ID, COUNT(TRAVEL_ID) AS CNTFROM TRAVELSGROUP BY…

Answered: The InstantRide User Satisfaction team…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Can someone help?

Thank you in advance

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.