Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the sum of the balances of all customers for each sales rep. 2 0 Customer table [ [ CUST _ ID , FIRST

List the sum of the balances of all customers for each sales rep. 20
Customer
\table[[CUST_ID,FIRST_NAME,LAST_NAME,ADDRESS,CITY,STATE,POSTAL,EMAIL,BALANCE,CREDIT_LIIMIT,REP_ID],[125,Joey,Smith,17 Fourth St,Fulton,CA,82414,jsmith17@example.com,80.68,500,05],[182,Billy,Rufton,21 Simple Cir,Grove,CA,82435,billyruff@example.com,43.13,750,10],[227,Sandra,Pincher,53 Verde Ln,Congaree,CA,82440,spinch2@example.com,156.38,500,15],[294,Samantha,Smith,14 Rock Ln,Northfield,CA,82440,ssmith5@example.com,58.6,500,10],[314,Tom,Rascal,1 Rascal Farm Rd,Fulton,CA,82414,trascal3@example.com,17.25,250,15],[375,Melanie,Jackson,42 Blackwater Way,Mesa,CA,82433,mjackson5@example.com,252.25,250,05],[435,James,Gonzalez,16 Rockway Rd,Almondton,CA,82450,igonzo@example.com,230.4,1000,15],[492,Elmer,Jackson,22 Jackson Farm Rd,Grove,CA,82435,ejackson4@example.com,45.2,500,10],[543,Angie,Hendricks,27 Locklear Ln,Congaree,CA,82440,ahendricks7@example.com,315,750,05],[616,Sally,Cruz,19918 th Ave,Northfield,CA,82440,scruz5@example.com,8.33,500,15],[721,Leslie,Smith,123 Sheepland Rd,Mesa,CA,82433,Ismith12@example.com,166.65,1000,10],[795,Randy,Blacksmith,75 Stream Rd,Grove,CA,82414,rblacksmith6@example.com,61.5,500,05]]
Sales_rep
\table[[REP_ID,FIRST_NAME,LAST_NAME,ADDRESS,CITY,STATE,POSTAL,CELL_PHONE,COMMISSION,RATE],[05,Susan,Garcia,42 Mountain Ln,Grove,CA,82414,307-824-1245,12743.16,.04],[10,Richard,Miller,87 Pikes Dr,Fullton,CA,82440,307-406-4321,20872.11,.06],[15,Donna,Smith,312 Oak Rd,Northfield,CA,82440,307-982-8401,14912.92,.04],[20,Daniel,Jackson,19 Lookout Dr,Sefton,CA,82433,307-883-9481,0,.04]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Apache Cassandra Development

Authors: Vivek Mishra

1st Edition

1484201426, 9781484201428

More Books

Students also viewed these Databases questions