REP RATE COMMISSION STATE ZIP CITY FIRST NAME STREET REP LAST NUM NAME $20,542.50 0.05 33321 FL 624 Randall Grove Kaiser Valerie 20 $39,216.00 0.07 33553 FL Sheldon Richard 532 Jackson 35 Hull $23,487.00 0.05 33336 1626 Taylor Fillmore FL Perez 65 Juan CUSTOMER CREDIT BALANCE STATE ZIP REP LIMIT NUM CITY CUSTOMER STREET CUSTOMER NUM NAME $6,550.00 $7,500.00 20 Al's Appliance and Sport Fillmore 33336 FL 148 2837 Greenway $431.50 $10,000.00 35 Grove Brookings Direct 33321 282 3827 Devon FL $5,785.00 $7,500.00 65 33503 $5,285.25 $5,000.00 35 382 Wildwood Northfield FL 356 Ferguson's 33146 The FL 408 Crystal 1828 Raven Everything Shop Bargains Galore 3829 Central Grove FL $3,412.00 $10,000.00 65 462 33321 Kline's 838 Ridgeland Fillmore 524 33336 $12,762.00 $15,000.00 20 FL 372 Oxford Johnson's Sheldon 608 FL $2,106.00 $10,000.00 65 33553 Department Store 282 Evergreen Altonville FL Lee's Sport and Appliance 687 32543 $2,851.00 $5,000.00 35 282 Columbla Sheldon Deerfield's 725 FL $248.00 $7,500.00 35 33553 Four Seasons All Season 28 Lakevlew 842 Grove FL $8,221.00 $7,500.00 20 33321 ORDERS ORDER_LINE CUSTOMER ORDER ORDER_ ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE NUM NUM DATE АТ94 21608 11 $21.95 10/20/2007 148 21608 21610 DR93 $495.00 1 10/20/2007 356 21610 21610 DW11 1 $399.99 10/21/2007 408 21613 21613 KL62 4 $329,95 10/21/2007 282 21614 КТоЗ 21614 $595.00 2 10/23/2007 608 21617 BV06 21617 $794.95 2 10/23/2007 148 21619 21617 $150.00 CD52 4 10/23/2007 608 21623 DR93 $495.00 21619 1 21623 $1,290.00 2 KV29 Iub PART PART NUM DESCRIPTION ON HAND CLASS WAREHOUSE PRICE 50 HW $24.95 AT94 Iron 3 45 SG $794.95 2 Home Gym BV06 CD52 $165.00 Microwave Oven 32 AP 1 21 HW Cordless Drill $129.95 DL71 3 8 AP $495.00 DR93 Gas Range 2 Washer DW11 3 $399.99 12 AP FD21 $159.95 Stand Mixer 22 HW 3 Dryer KL62 $349.95 12 AP 1 Ктоз 8 AP Dishwasher $595.00 3 KV29 Treadmill $1,390.00 9 SG 2
REP RATE COMMISSION STATE ZIP CITY FIRST NAME STREET REP LAST NUM NAME $20,542.50 0.05 33321 FL 624 Randall Grove Kaiser Valerie 20 $39,216.00 0.07 33553 FL Sheldon Richard 532 Jackson 35 Hull $23,487.00 0.05 33336 1626 Taylor Fillmore FL Perez 65 Juan CUSTOMER CREDIT BALANCE STATE ZIP REP LIMIT NUM CITY CUSTOMER STREET CUSTOMER NUM NAME $6,550.00 $7,500.00 20 Al's Appliance and Sport Fillmore 33336 FL 148 2837 Greenway $431.50 $10,000.00 35 Grove Brookings Direct 33321 282 3827 Devon FL $5,785.00 $7,500.00 65 33503 $5,285.25 $5,000.00 35 382 Wildwood Northfield FL 356 Ferguson's 33146 The FL 408 Crystal 1828 Raven Everything Shop Bargains Galore 3829 Central Grove FL $3,412.00 $10,000.00 65 462 33321 Kline's 838 Ridgeland Fillmore 524 33336 $12,762.00 $15,000.00 20 FL 372 Oxford Johnson's Sheldon 608 FL $2,106.00 $10,000.00 65 33553 Department Store 282 Evergreen Altonville FL Lee's Sport and Appliance 687 32543 $2,851.00 $5,000.00 35 282 Columbla Sheldon Deerfield's 725 FL $248.00 $7,500.00 35 33553 Four Seasons All Season 28 Lakevlew 842 Grove FL $8,221.00 $7,500.00 20 33321 ORDERS ORDER_LINE CUSTOMER ORDER ORDER_ ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE NUM NUM DATE АТ94 21608 11 $21.95 10/20/2007 148 21608 21610 DR93 $495.00 1 10/20/2007 356 21610 21610 DW11 1 $399.99 10/21/2007 408 21613 21613 KL62 4 $329,95 10/21/2007 282 21614 КТоЗ 21614 $595.00 2 10/23/2007 608 21617 BV06 21617 $794.95 2 10/23/2007 148 21619 21617 $150.00 CD52 4 10/23/2007 608 21623 DR93 $495.00 21619 1 21623 $1,290.00 2 KV29 Iub PART PART NUM DESCRIPTION ON HAND CLASS WAREHOUSE PRICE 50 HW $24.95 AT94 Iron 3 45 SG $794.95 2 Home Gym BV06 CD52 $165.00 Microwave Oven 32 AP 1 21 HW Cordless Drill $129.95 DL71 3 8 AP $495.00 DR93 Gas Range 2 Washer DW11 3 $399.99 12 AP FD21 $159.95 Stand Mixer 22 HW 3 Dryer KL62 $349.95 12 AP 1 Ктоз 8 AP Dishwasher $595.00 3 KV29 Treadmill $1,390.00 9 SG 2
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%
What is the SQL command for the following, using the data attached:
Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit limits.
Transcribed Image Text:REP
RATE
COMMISSION
STATE ZIP
CITY
FIRST
NAME
STREET
REP LAST
NUM NAME
$20,542.50 0.05
33321
FL
624 Randall
Grove
Kaiser Valerie
20
$39,216.00 0.07
33553
FL
Sheldon
Richard 532 Jackson
35
Hull
$23,487.00 0.05
33336
1626 Taylor Fillmore FL
Perez
65
Juan
CUSTOMER
CREDIT
BALANCE
STATE ZIP
REP
LIMIT NUM
CITY
CUSTOMER
STREET
CUSTOMER
NUM
NAME
$6,550.00 $7,500.00 20
Al's Appliance
and Sport
Fillmore
33336
FL
148
2837
Greenway
$431.50 $10,000.00 35
Grove
Brookings
Direct
33321
282
3827 Devon
FL
$5,785.00 $7,500.00 65
33503 $5,285.25 $5,000.00 35
382 Wildwood Northfield FL
356
Ferguson's
33146
The
FL
408
Crystal
1828 Raven
Everything
Shop
Bargains
Galore
3829 Central Grove
FL
$3,412.00 $10,000.00 65
462
33321
Kline's
838 Ridgeland Fillmore
524
33336 $12,762.00 $15,000.00 20
FL
372 Oxford
Johnson's
Sheldon
608
FL
$2,106.00 $10,000.00 65
33553
Department
Store
282 Evergreen Altonville FL
Lee's Sport
and Appliance
687
32543 $2,851.00 $5,000.00 35
282 Columbla Sheldon
Deerfield's
725
FL
$248.00 $7,500.00 35
33553
Four Seasons
All Season
28 Lakevlew
842
Grove
FL
$8,221.00 $7,500.00 20
33321
Transcribed Image Text:ORDERS
ORDER_LINE
CUSTOMER
ORDER ORDER_
ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE
NUM
NUM
DATE
АТ94
21608
11
$21.95
10/20/2007 148
21608
21610
DR93
$495.00
1
10/20/2007 356
21610
21610
DW11
1
$399.99
10/21/2007 408
21613
21613
KL62
4
$329,95
10/21/2007 282
21614
КТоЗ
21614
$595.00
2
10/23/2007 608
21617
BV06
21617
$794.95
2
10/23/2007 148
21619
21617
$150.00
CD52
4
10/23/2007 608
21623
DR93
$495.00
21619
1
21623
$1,290.00
2
KV29
Iub
PART
PART NUM DESCRIPTION
ON HAND CLASS WAREHOUSE PRICE
50 HW
$24.95
AT94
Iron
3
45 SG
$794.95
2
Home Gym
BV06
CD52
$165.00
Microwave Oven
32 AP
1
21 HW
Cordless Drill
$129.95
DL71
3
8 AP
$495.00
DR93
Gas Range
2
Washer
DW11
3
$399.99
12 AP
FD21
$159.95
Stand Mixer
22 HW
3
Dryer
KL62
$349.95
12 AP
1
Ктоз
8 AP
Dishwasher
$595.00
3
KV29
Treadmill
$1,390.00
9 SG
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 4 steps with 2 images
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