Can someone help with this? User Satisfaction team wants to send monthly summaries for each user. They need the following details with the user ID:The last day of the month when the users traveled most recentlyOne week after the last day of the month when the users traveled most recentlyYou need to return a three-column output with USER_ID, LAST_TRAVEL_MONTH and NOTIFICATION. LAST_TRAVEL_MONTH should be calculated using the MAX of the LAST_DAY of the TRAVEL_END_TIME field. Similarly, NOTIFICATION should be calculated with DATE_ADD function to add one week. Scenario and Database Model: Instant RideInstantRide is the new ride sharing application in the city and it has just started its operations.With the help of the Instant Ride 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 Table2001200220032004USER_FIRST_NAMEWillieJustinAnthonyEceJackRyanNursinSarahBobbyRandyJoseDRIVERS TableNursinButlerHowardIn 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_RATING18745011953853YilmazUSER_LAST_NAME1735487Hill1734747CollinsYilmazPriceGriffinClarkThomasYilmaz2019-09-122019-09-092019-09-152019-08-1511USER_EMAILj.hill@xmail.comr.collins@xmail.comn.atak@gmail.coms.price@xmail.comb.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comn.yilmaz@xmail.com114.83.50 In the CARS table, all the cars in the Instant Ride system are kept with the license plate, modeland year:CAR_ID1001100210031004CARS TableTRAVEL ID50025001500450065007500850095010TRAVEL START TIME2015-10-01 04:042015-10-01 08:57:332016-10-01 13:31:202015-10-02 08:MAR2015-10-02 16:31M2015-10-03 19:12:142015-10-05 160632015-10-03 17:17:122015-10-05 21:16:482019-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:102015-10-01 08:12:382010-10-01 14:102015-10-4701582011-10-02 14:102019-10-43 19:28:452019-10-05 16:08:562019-10-43 17:37:422019-10-05 21:26:182019-10-43 23:39:10TRAVEL START LOCATION1514 York Road47 Church Street2 WindsorCAR MODEL2 Queensway50 Mina39 Park Road37 The Drive77 Mil Road16 Church RoadTOYOTA PRIUSTESLA MODEL 3TOYOTA AURISMERCEDES E200TRAVEL END LOCATIONChurch Lane68 High Street35 W27 Mainan24 Milane23 any91 West Street17 Stanley Road724 Spring Road30 North RoadTRAVEL PRICE15.4412.3714.814.4125.1213.5525.62DRIVER ID2001200120072003200120032002CAR YEAR2001200120032018201920192019CAR ID USER ID1001008100110031002100410031005100220023001300730073005300130053003TRAVEL DISCOUNTNULLMALNULL0.13MAI0.100.140.25MALYou are assigned as the database administrator to collect and manage transactional data of theInstant Ride 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.

A relation refers to tables in database with relation of rows with the columns. SQL is structured…

Answered: Can someone help with this? User…

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 with this?

User Satisfaction team wants to send monthly summaries for each user. They need the following details with the user ID:

The last day of the month when the users traveled most recently
One week after the last day of the month when the users traveled most recently

You need to return a three-column output with USER_ID, LAST_TRAVEL_MONTH and NOTIFICATION. LAST_TRAVEL_MONTH should be calculated using the MAX of the LAST_DAY of the TRAVEL_END_TIME field. Similarly, NOTIFICATION should be calculated with DATE_ADD function to add one week.