Task 4:The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column.Task: Find all travels where an above average discount was applied. (SQL Database Test) DRIVER_IDDRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_IDDRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKEDDRIVER RATING| 2001WillieButler18745012019-09-1214.42002JustinHoward19538532019-09-0914.82003AnthonyWalker17354872019-09-153.52004EceYilmaz17347472019-08-15 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

For given InstantRide Finance team database, need to write query to create a SELECT statement which…

Answered: The InstantRide Finance team also wants…

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

Task 4:

The InstantRide Finance team also wants to analyze travels where more than the average discount rate is applied. They want to look for any correlation between higher discount amounts against other travel characteristics. You need to create a SELECT statement which is filtered with a subquery to calculate the AVG of the TRAVEL_DISCOUNT column.

Task: Find all travels where an above average discount was applied. (SQL Database Test)

DRIVER_ID
DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_ID
DRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKED
DRIVER RATING
| 2001
Willie
Butler
1874501
2019-09-12
1
4.4
2002
Justin
Howard
1953853
2019-09-09
1
4.8
2003
Anthony
Walker
1735487
2019-09-15
3.5
2004
Ece
Yilmaz
1734747
2019-08-15

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