Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.
Transcribed Image Text:23; 24; 25
EMPLOYEE TABLE
EMPLOYEE_ID FIRST_NAME
emp101
emp102
emp103
emp104
emp105
DONATOR TABLE
DONATOR_ID
20111
20112
20113
20114
20115
DONATION_ID
7111
DONATION TABLE
7112
7113
7114
7115
7116
23; 24; 25
DELIVERY TABLE
DELIVERY_ID
511
512
513
514
515
516
ret001
ret002
Jeff
8111
8112
Kevin
Adanya
8113
8114
Adebayo
Xolanil
8115
8116
Jeff
Stephen
James
Kelly
Abraham
20111
20112
The Independent Institute of Education (Pty) Ltd 2023
FIRST_NAME
20113
20115
DONATOR_ID
20114
20113
RETURNS TABLE
RETURN_ID RETURN_DATE
25 May 2022
No notes
INVOICE TABLE
INVOICE_NUM CUSTOMER_ID
SURNAME
Davis
Marks
DELIVERY_NOTES
25 May 2022
Andrews
Dryer
Samson
11011
11013
11012
11015
11011
11015
Double packaging requested
Delivery to work address
Signature required
Birthday present wrapping
required
Delivery to work address
Watson
Jones
Joe
Ross
Clark
CONTACT NUMBER
0877277521
0837377522
SURNAME
0817117523
0797215244
0827122255
DONATION
KIC Fridge
Samsung 42inch
LCD
Sharp Microwave
6 Seat Dining
room table
Lazyboy Sofa
JVC Surround
Sound System
REASON
Customer not
satisfied with
product
Product had
broken section
INVOICE_DATE
15 May 2022
15 May 2022
17 May 2022
17 May 2022
17 May 2022
18 May 2022
PRICE
11011
R 599
11013
R 1 299
R 1 599
R 799
R 1 199
DISPATCH_DATE
10 May 2022
12 May 2022
12 May 2022
12 May 2022
18 May 2022
R 179
20 May 2022
CONTACT NUMBER EMAIL
0827172250
0837865670
0878978650
0826575650
0797656430
CUSTOMER_ID
ADDRESS
10 main
road
EMPLOYEE_ID
emp103
emp101
emp101
emp102
emp102
emp103
18 water
road.
21 circle
lane
1 sea road.
12 main
road.
7116
7114
EMAIL
jand@isat.com
7111
7114
7112
7113
7115
7116
km@isat.com
aa@isat.com
aryer@isat.com
xosam@isat.com
jwatson@ymail.com
joness@ymail.com
jj@isat.com
kross@gsat.com
aclark@ymail.com
DONATION_DATE
1 May 2022
3 May 2022
DONATION_ID
3 May 2022
5 May 2022
7 May 2022
9 May 2022
DELIVERY_DATE
15 May 2022
15 May 2022
17 May 2022
15 May 2022
19 May 2022
25 May 2022
DONATION_ID EMPLOYEE_ID
emp101
2023
emp103
Page 4 of 19
DELIVERY_ID
511
512
513
514
515
516
2023
Transcribed Image Text:CUSTOMER TABLE
CUSTOMER_ID FIRST_NAME SURNAME ADDRESS
11011
11012
11013
11014
11015
Jack
Pat
Andre
Kevin
Lucy
Smith
Hendricks 22 Water Rd
Clark
Jones
18 Water Rd
Williams
101 Summer
Lane
55 Mountain
way
5 Main rd
CONTACT NUMBER EMAIL
0877277521
0863257857
0834567891
0612547895
0827238521
jsmith@isat.com
ph@mcom.co.za
aclark@mcom.co.za
kj@isat.co.za
lw@mcal.co.za
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY