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.
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.
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter4: Networks And Cloud Computing
Section: Chapter Questions
Problem 7SAT
Related questions
Question
100%
The InstantRide User Satisfaction team is a core team for InstantRide, 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.
![USER_ID
USER FIRST_NAME
USER LAST_NAME
USER_EMAIL
3001
Jack
Hill
j.hill@xmail.com
3002
Ryan
Collins
r.collins@xmail.com
3003
Nursin
Yilmaz
n.atak@gmail.com
3004
Sarah
Price
s.price@xmail.com
3005
Bobby
Griffin
b.griffin@xmail.com
3006
Randy
Clark
r.clark@xmail.com
3007
Jose
Thomas
j.thomas@xmail.com
3008
Nursin
Yilmaz
n.yilmaz@xmail.com](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8552b95a-ccec-4e92-ac6b-3c3a99a88e41%2F20646fc4-9012-41c0-b663-d3c5a2683acd%2Fxjgxw7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:USER_ID
USER FIRST_NAME
USER LAST_NAME
USER_EMAIL
3001
Jack
Hill
j.hill@xmail.com
3002
Ryan
Collins
r.collins@xmail.com
3003
Nursin
Yilmaz
n.atak@gmail.com
3004
Sarah
Price
s.price@xmail.com
3005
Bobby
Griffin
b.griffin@xmail.com
3006
Randy
Clark
r.clark@xmail.com
3007
Jose
Thomas
j.thomas@xmail.com
3008
Nursin
Yilmaz
n.yilmaz@xmail.com
![TRAVEL_ID
TRAVEL_START TIME
TRAVEL END TIME
TRAVEL START LOCATION
TRAVEL_END_LOCATION
TRAVEL_PRICE
DRIVER_ID
CAR ID
USER_ID
TRAVEL DISCOUNT
5001
2019-10-01 04:04:55
2019-10-01 04:14:19
9614 York Road
84 Church Lane
15.44
2001
1003
3005
NULL
5002
2019-10-01 05:57:33
2019-10-01 06:12:33
47 Church Street
68 High Street
20.56
2001
1003
3006
NULL
5003
2019-10-01 13:35:20
2019-10-01 13:45:10
2 Windsor Road
95 West Street
12.32
2002
1001
3002
NULL
5004
2019-10-02 08:44:48
2019-10-02 09:15:28
9060 Mill Lane
27 Main Road
30.49
2003
1002
3001
0.13
5005
2019-10-02 16:38:54
2019-10-02 16:48:10
2 Queensway
24 Mill Lane
11.15
2001
1003
3007
NULL
5006
2019-10-03 19:12:14
2019-10-03 19:23:45
50 Main Road
93 Broadway
14.61
2003
1002
3007
0.10
5007
2019-10-03 16:06:36
2019-10-03 16:08:56
39 Park Road
91 West Street
4.41
2002
1004
3003
0.14
5008
2019-10-03 17:17:12
2019-10-03 17:37:42
37 The Drive
17 Stanley Road
25.12
2001
1003
3001
0.25
5009
2019-10-03 21:16:48
2019-10-03 21:26:18
77 Mill Road
724 Springfield Road
13.55
2001
1003
3005
NULL
5010
2019-10-03 23:21:40
2019-10-03 23:39:10
16 Church Road
30 North Road
25.62
2003
1002
3003
0.20](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8552b95a-ccec-4e92-ac6b-3c3a99a88e41%2F20646fc4-9012-41c0-b663-d3c5a2683acd%2F5fksee9_processed.jpeg&w=3840&q=75)
Transcribed Image Text:TRAVEL_ID
TRAVEL_START TIME
TRAVEL END TIME
TRAVEL START LOCATION
TRAVEL_END_LOCATION
TRAVEL_PRICE
DRIVER_ID
CAR ID
USER_ID
TRAVEL DISCOUNT
5001
2019-10-01 04:04:55
2019-10-01 04:14:19
9614 York Road
84 Church Lane
15.44
2001
1003
3005
NULL
5002
2019-10-01 05:57:33
2019-10-01 06:12:33
47 Church Street
68 High Street
20.56
2001
1003
3006
NULL
5003
2019-10-01 13:35:20
2019-10-01 13:45:10
2 Windsor Road
95 West Street
12.32
2002
1001
3002
NULL
5004
2019-10-02 08:44:48
2019-10-02 09:15:28
9060 Mill Lane
27 Main Road
30.49
2003
1002
3001
0.13
5005
2019-10-02 16:38:54
2019-10-02 16:48:10
2 Queensway
24 Mill Lane
11.15
2001
1003
3007
NULL
5006
2019-10-03 19:12:14
2019-10-03 19:23:45
50 Main Road
93 Broadway
14.61
2003
1002
3007
0.10
5007
2019-10-03 16:06:36
2019-10-03 16:08:56
39 Park Road
91 West Street
4.41
2002
1004
3003
0.14
5008
2019-10-03 17:17:12
2019-10-03 17:37:42
37 The Drive
17 Stanley Road
25.12
2001
1003
3001
0.25
5009
2019-10-03 21:16:48
2019-10-03 21:26:18
77 Mill Road
724 Springfield Road
13.55
2001
1003
3005
NULL
5010
2019-10-03 23:21:40
2019-10-03 23:39:10
16 Church Road
30 North Road
25.62
2003
1002
3003
0.20
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781337097536/9781337097536_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781337097536/9781337097536_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning