Task 5: User Satisfaction team wants to send monthly summaries for…

/in /by

Question Answered step-by-step Task 5: User Satisfaction team wants to send monthly summaries for… Task 5: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.Image transcription textTRAVEL_ID TRAVEL_START_TIME TRAVEL_END_TIME TRAVEL_START_LOCATIONTRAVEL_END_LOCATION TRAVEL_PRICE DRIVER_ID CAR_ID USER_ID TRAVEL_DISCOUNT 50012019-10-01 04:04:55 2019-10-01 04:14:19 9614 York Road 84 Church Lane 15.44 2001 1003 3005… Show more… Show more  Computer Science Engineering & Technology MYSQL IT COP3703 Share QuestionEmailCopy link Comments (0)