From each sales rep, list the rep number, description, number ordered and storehouse from their sales at TAL.
From each sales rep, list the rep number, description, number ordered and storehouse from their sales at TAL.
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
100%
A guide to SQL. TAL tables
From each sales rep, list the rep number, description, number ordered and storehouse from their sales at TAL.

Transcribed Image Text:REP
REP_NUM LAST_NAME FIRST_NAME STREET
CITY
STATE POSTAL_CODE COMMISSION
RATE
$23,457.50
$41,317.00
$27,789.25
$0.00
15
Rafael
724 Vinca Dr.
Grove
СА
90092
Campos
Gradey
0.06
632 Liatris St. Fullton
1785 Tyler Ave. Northfield
267 Oakley St. Congaree
30
Megan
СА
90085
0.08
45
Tian
Hui
CA
90098
0.06
60
Sefton
Janet
СА
90097
0.06
CUSTOMER
CUSTOMER_NUM CUSTOMER_NAME STREET
28 Laketon St.
CITY
STATE POSTAL_CODE BALANCE CREDIT_LIMIT REP_NUM
$7,500.00 15
$10,000.00 30
$7,500.00 45
126
Toys Galore
Fullton
CA
90085
$1,210.25
260
Brookings Direct
452 Columbus Dr. Grove
СА
90092
$575.00
342 Magee St.
The Everything
Shop
334
Congaree CA
90097
$2,345.75
386
Johnson's
124 Main St.
Northfield CA
90098
$879.25
$7,500.00 30
Department
Store
440
Grove
3456 Central Ave. Fullton
СА
90085
$345.00
$5,000.00 45
Historical
Museum Store
502
Cards and More
167 Hale St.
Mesa
СА
90104
$5,025.75
$5,000.00 15
Almondton
586
3345 Devon Ave.
Almondton CA
90125
$3,456.75
$15,000.00 45
General Store
665
Cricket Gift Shop 372 Oxford St.
Grove
CA
90092
$678.90
$7,500.00 30
12 Rising Sun Ave. Congaree CA
Northfield CA
$10,000.00 15
$7,500.00 45
713
Cress Store
90097
$4,234.60
796
Unique Gifts
786 Passmore St.
90098
$124.75
824
Kline's
945 Gilham St.
Mesa
CA
90104
$2,475.99
$15,000.00 30
893
All Season Gifts
382 Wildwood Ave. Fullton
СА
90085
$935.75
$7,500.00 15

Transcribed Image Text:ORDERS
ORDER_LINE
ORDER_DATE CUSTOMER_NUM ORDER_NUM ITEM_NUM
CD33
ORDER_NUM
NUM_ORDERED QUOTED_PRICE
51608
$86.99
51608
10/12/2015
126
51610
KL78
25
$10.95
51610
10/12/2015 334
51610
TR40
10
$13.99
51613
10/13/2015 386
51613
DL51
$104.95
10/13/2015 | 260
10/15/2015 | 586
51614
51614
FD11
1
$124.95
51617
51617
NL89
$115.99
51619
10/15/2015
126
51617
TW35
$116.95
51619
FD11
$121.95
10/15/2015 586
10/16/2015 796
51623
51623
DR67
$29.95
51625
51623
FH24
12
$36.95
51623
KD34
10
$13.10
51625
МТОЗ
$45.79
ITEM
ITEM_NUM DESCRIPTION
ON_HAND CATEGORY
STOREHOUSE
PRICE
АН74
Patience
9 GME
3.
$22.99
BR23
Skittles
21 GME
$29.99
CD33
Wood Block Set (48 piece)
36 TOY
1
$89.49
DL51
Classic Railway Set
12 TOY
3
$107.95
DR67
Giant Star Brain Teaser
24 PZL
2
$31.95
DW23
Mancala
40 GME
3
$50.00
FD11
Rocking Horse
8 TOY
3
$124.95
FH24
Puzzle Gift Set
65 PZL
1
$38.95
KA12
Cribbage Set
56 GME
$75.00
KD34
Pentominoes Brain Teaser
60 PZL
$14.95
KL78
Pick Up Sticks
110 | GME
1
$10.95
MT03
Zauberkasten Brain Teaser
45 PZL
1
$45.79
NL89
Wood Block Set (62 piece)
32| ТOY
3
$119.75
TR40
Tic Tac Toe
75 GME
2
$13.99
TW35
Fire Engine
30 TOY
2
$118.95
4.
2.
Expert Solution

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

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
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education