5. For each order, list the order number, quoted price and the item description, when the category is TOY. 6. Use the inner join syntax to show the customer name and the matching order dates.

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...
icon
Related questions
Question

5. For each order, list the order number, quoted price and the item description, when the category is TOY.
6. Use the inner join syntax to show the customer name and the matching order dates.

REP
ITEM
EDIT REP_NUM LAST_NAME FIRST_NAME
STREET
STATE POSTAL CODE COMMISSION RATE
EDIT ITEM_NUM
DESCRIPTION
ON HAND CATEGORY STOREHOUSE PRICE
CITY
15
Саmpos
Rafael
724 Vinca Dr.
Grove
CA
90092
23457.5
06
AH74
Patience
9
GME
3
22.99
30
Gradey
Megan
632 Liatris St.
Fullton
CA
90085
41317
08
BR23
Skittles
21
GME
2
29.99
45
Tian
Hui
1785 Tyler Ave.
Northfield CA
90098
27789.25
06
CD33
Wood Block Set (48 piece) 36
TOY
1
89.49
60
Sefton
Janet
267 Oakley St.
Congaree CA
90097
06
DL51
Classic Railway Set
12
ΤΟΥ
3
107.95
row(s) 1-4 of 4
DR67
Giant Star Brain Teaser
24
PZL
2
31.95
DW23
Mancala
40
GME
3
50
CUSTOMER
FD11
Rocking Horse
8
TOY
3
124.95
FH24
Puzzle Gift Set
65
PZL
1
38.95
EDIT CUSTOMER_NUM
CUSTOMER NAME
STREET
CITY
STATE POSTAL_CODE BALANCE CREDIT LIMIT REP NUM
28 Laketon St.
Fulton
1210.25
КА12
Cribbage Set
56
GME
3
75
126
Toys Galore
СА
90085
7500
15
260
Brookings Direct
452 Columbus Dr
Grove
KD34
Pentominoes Brain Teaser
60
PZL
2
14.95
CA
90092
575
10000
30
334
The Everything Shop
342 Magee St
Congaree
CA
90097
2345.75
7500
45
KL78
Pick Up Sticks
110
GME
10.95
386
Johnson's Department Store
124 Main St.
Northfield
CA
90098
879.25
7500
30
MT03
Zauberkasten Brain Teaser
45
PZL
45.79
440
Grove Historical Museum Store 3456 Central Ave.
Fullton
CA
90085
345
5000
45
NL89
Wood Block Set (62 piece)
32
ΤΟΥ
3
119.75
502
Cards and More
167 Hale St.
Mesa
CA
90104
5025.75
5000
15
TR40
Tic Tac Toe
75
GME
13.99
586
Almondton General Store
3345 Devon Ave.
Almondton CA
90125
3456.75
15000
45
TW35
Fire Engine
30
ΤΟΥ
2
118.95
665
Cricket Gift Shop
372 Oxford St.
Grove
CA
90092
678 9
7500
30
row(s) 1- 15 of 15
713
Cress Store
12 Rising Sun Ave. Congaree
CA
90097
4234.6
10000
15
796
Unique Gifts
786 Passmore St
Northfield
CA
90098
124.75
7500
45
824
Kline's
945 Giham St.
Mesa
CA
90104
2475.99
15000
30
893
All Season Gifts
382 Wildwood Ave
Fullton
CA
90085
935.75
7500
15
row(s) 1- 12 of 12
ORDERS
OPRDER LINE
EDIT ORDER NUM ORDER DATE CUSTOMER_NUM
EDIT ORDER_NUM ITEM_NUM NUM_ORDERED QUOTED_PRICE
51608
CD33
86,99
51608
10/12/2015
126
51610
KL78
25
10.95
51610
10/12/2015
334
51610
TR40
10
13.99
51613
DL51
104.95
51613
10/13/2015
386
51614
FD11
1
124.95
51614
10/13/2015
260
51617
NL89
4.
115.99
51617
10/15/2015
586
51617
TW35
3
116.95
51619
FD11
2
121.95
51619
10/15/2015
126
51623
DR67
29.95
51623
10/15/2015
586
51623
FH24
12
36.95
51625
10/16/2015
796
51623
KD34
10
13.1
51625
MT03
8.
45.79
row(s) 1 -8 of 8
row(s) 1- 12 of 12
Transcribed Image Text:REP ITEM EDIT REP_NUM LAST_NAME FIRST_NAME STREET STATE POSTAL CODE COMMISSION RATE EDIT ITEM_NUM DESCRIPTION ON HAND CATEGORY STOREHOUSE PRICE CITY 15 Саmpos Rafael 724 Vinca Dr. Grove CA 90092 23457.5 06 AH74 Patience 9 GME 3 22.99 30 Gradey Megan 632 Liatris St. Fullton CA 90085 41317 08 BR23 Skittles 21 GME 2 29.99 45 Tian Hui 1785 Tyler Ave. Northfield CA 90098 27789.25 06 CD33 Wood Block Set (48 piece) 36 TOY 1 89.49 60 Sefton Janet 267 Oakley St. Congaree CA 90097 06 DL51 Classic Railway Set 12 ΤΟΥ 3 107.95 row(s) 1-4 of 4 DR67 Giant Star Brain Teaser 24 PZL 2 31.95 DW23 Mancala 40 GME 3 50 CUSTOMER FD11 Rocking Horse 8 TOY 3 124.95 FH24 Puzzle Gift Set 65 PZL 1 38.95 EDIT CUSTOMER_NUM CUSTOMER NAME STREET CITY STATE POSTAL_CODE BALANCE CREDIT LIMIT REP NUM 28 Laketon St. Fulton 1210.25 КА12 Cribbage Set 56 GME 3 75 126 Toys Galore СА 90085 7500 15 260 Brookings Direct 452 Columbus Dr Grove KD34 Pentominoes Brain Teaser 60 PZL 2 14.95 CA 90092 575 10000 30 334 The Everything Shop 342 Magee St Congaree CA 90097 2345.75 7500 45 KL78 Pick Up Sticks 110 GME 10.95 386 Johnson's Department Store 124 Main St. Northfield CA 90098 879.25 7500 30 MT03 Zauberkasten Brain Teaser 45 PZL 45.79 440 Grove Historical Museum Store 3456 Central Ave. Fullton CA 90085 345 5000 45 NL89 Wood Block Set (62 piece) 32 ΤΟΥ 3 119.75 502 Cards and More 167 Hale St. Mesa CA 90104 5025.75 5000 15 TR40 Tic Tac Toe 75 GME 13.99 586 Almondton General Store 3345 Devon Ave. Almondton CA 90125 3456.75 15000 45 TW35 Fire Engine 30 ΤΟΥ 2 118.95 665 Cricket Gift Shop 372 Oxford St. Grove CA 90092 678 9 7500 30 row(s) 1- 15 of 15 713 Cress Store 12 Rising Sun Ave. Congaree CA 90097 4234.6 10000 15 796 Unique Gifts 786 Passmore St Northfield CA 90098 124.75 7500 45 824 Kline's 945 Giham St. Mesa CA 90104 2475.99 15000 30 893 All Season Gifts 382 Wildwood Ave Fullton CA 90085 935.75 7500 15 row(s) 1- 12 of 12 ORDERS OPRDER LINE EDIT ORDER NUM ORDER DATE CUSTOMER_NUM EDIT ORDER_NUM ITEM_NUM NUM_ORDERED QUOTED_PRICE 51608 CD33 86,99 51608 10/12/2015 126 51610 KL78 25 10.95 51610 10/12/2015 334 51610 TR40 10 13.99 51613 DL51 104.95 51613 10/13/2015 386 51614 FD11 1 124.95 51614 10/13/2015 260 51617 NL89 4. 115.99 51617 10/15/2015 586 51617 TW35 3 116.95 51619 FD11 2 121.95 51619 10/15/2015 126 51623 DR67 29.95 51623 10/15/2015 586 51623 FH24 12 36.95 51625 10/16/2015 796 51623 KD34 10 13.1 51625 MT03 8. 45.79 row(s) 1 -8 of 8 row(s) 1- 12 of 12
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY