You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number compared with SUBSTR and UPPER functions.
You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number compared with SUBSTR and UPPER functions.
Chapter1: Getting Started With Excel
Section: Chapter Questions
Problem 2RA
Related questions
Question
The InstantRide User Satisfaction team received a phone call from a user who might have left her wallet in the car. She indicated that the license plate of the car was starting with BB-883 but unfortunately, she could not remember the full license plate number. The team wants to get all travel information for the cars with the license plate starting with BB-883. You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number compared with SUBSTR and UPPER functions.
![CAR_ID
CAR_PLATE
CAR_MODEL
CAR_YEAR
1001
ВB-542-АB
TOYOTA PRIUS
2018
1002
ВB-883-EE
TESLA MODEL 3
2019
1003
BB-451-ZN
TOYOTA AURIS
2019
1004
BB-189-MM
MERCEDES E200
2019](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8552b95a-ccec-4e92-ac6b-3c3a99a88e41%2F3acfe863-7ee3-41d4-8886-7db9e0a89e1b%2F5q0z6dk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:CAR_ID
CAR_PLATE
CAR_MODEL
CAR_YEAR
1001
ВB-542-АB
TOYOTA PRIUS
2018
1002
ВB-883-EE
TESLA MODEL 3
2019
1003
BB-451-ZN
TOYOTA AURIS
2019
1004
BB-189-MM
MERCEDES E200
2019
![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%2F3acfe863-7ee3-41d4-8886-7db9e0a89e1b%2Fkowbsb4_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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L