Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).
Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).
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
Related questions
Question
7. Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9e281a56-72cc-46d8-9143-bb4dda6b993a%2Fa13762c9-c4b3-4f46-82cd-92ce448dfe2f%2Fg077vct_processed.jpeg&w=3840&q=75)
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
![](/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.
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
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education