Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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.

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)
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...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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
SEE MORE TEXTBOOKS