Question

Complete Task 4, 5, 6

Instructions Page 3 of 3 query.sql 1 -- Write your query below and then click "Run Query" to execute it. To save multiple queries, click the "+" icon above. VE Task 4: </> The InstantRide User Satisfaction team is a core team for Instant Ride, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME Task Query the travel time for each ride. > Task 5: User Satisfaction team wants to send monthly summaries for each user. They need the following details with the user ID: SQL Viewer + • 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. Query completed Task 3/3 InstantRide 9

Answer 1

USER_ID, TIME DIFF ( TRAVEL-END_TIME, TRAVEL.START_TIME) Task 4:- > SELECT AS TRAVEL TIME FROM TRAVEL; USER_ID TRAVEL_TIME Touk 5i- You Can writing ease create new column for your Queries . TO find last day :- FROM column last-day Now, the SELECT LAST_DAY (TRAVEL_END_TIME) AS Last_day TRAVEL; can be used direetly. → SELECT USER_ID , MAX(last day) As Last-travel- month DATE_ADD(Last_travel month INTERVAL 7 DAY) AS lon maxilast_dowy) NOTIFICATION FROM TRAVEL GROUP BY USER-JOE Notification USER_ID Last travel month need the result to be in ascending / descending 4 If you coin add ORDER BY USERD ASC [DESC order of user-id then you at the end of the Query.

Task 6:- SELECT TRAVEL_ID , ROUND (TRAVEL_DISCOUNT, 2) AS DISCOUNT_AMOUNT WHERE TRAVEL_DISCOUNT IS NOT NULL; Discount Amount Travel ID » Y you can only only the video which have some discount than null values con no discount. other