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

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: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
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple table
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS