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. TRAVEL_IDTRAVEL_START TIMETRAVEL END TIMETRAVEL START LOCATIONTRAVEL_END_LOCATIONTRAVEL_PRICEDRIVER_IDCAR IDUSER_IDTRAVEL DISCOUNT50012019-10-01 04:04:552019-10-01 04:14:199614 York Road84 Church Lane15.44200110033005NULL50022019-10-01 05:57:332019-10-01 06:12:3347 Church Street68 High Street20.56200110033006NULL50032019-10-01 13:35:202019-10-01 13:45:102 Windsor Road95 West Street12.32200210013002NULL50042019-10-02 08:44:482019-10-02 09:15:289060 Mill Lane27 Main Road30.492003100230010.1350052019-10-02 16:38:542019-10-02 16:48:102 Queensway24 Mill Lane11.15200110033007NULL50062019-10-03 19:12:142019-10-03 19:23:4550 Main Road93 Broadway14.612003100230070.1050072019-10-03 16:06:362019-10-03 16:08:5639 Park Road91 West Street4.412002100430030.1450082019-10-03 17:17:122019-10-03 17:37:4237 The Drive17 Stanley Road25.122001100330010.2550092019-10-03 21:16:482019-10-03 21:26:1877 Mill Road724 Springfield Road13.55200110033005NULL50102019-10-03 23:21:402019-10-03 23:39:1016 Church Road30 North Road25.622003100230030.20

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

Answered: The InstantRide User Satisfaction team…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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.

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

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions