Question: 2. Determine the average customer balance by representative. Show the resulting average along with the representative's full name as last name, first name in a

 2. Determine the average customer balance by representative. Show the resulting

average along with the representative's full name as "last name, first name"

2. Determine the average customer balance by representative. Show the resulting average along with the representative's full name as "last name, first name" in a single column, order by the representative's last name

Rep RepNum LastName FirstName Street City State PostalCode Commission Rate 15 Campos Rafael 724 Vinca Dr. Grove CA 90092 $23,457.50 0.06 30 Gradey Megan 632 Liatris St. Fullton CA 90085 S41,317.00 0.08 Hui 1785 Tyler Ave. Northfield CA 90098 $27,789,25 0.06 45 60 Sefton Janet 267 Oakley St. Congaree ICA 90097 S0.000 0.06 Customer Customer Num CustomerName Street ICity I State PostalCode Balance ICreditLimit RepNum 126 Toys Galore 28 Laketon St. Fulton CA 90085 $1,210.25 $7,500.00 15 260 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 S10,000.00 30 The Everything 342 Magee St. Congaree CA 90097 $2,345.75 S7,500.00 45 124 Main St. Northfield CA 90098 $879.25 $7,500.00 30 ohnson's Store 356 Central Ave. Fulton CA 90085 $345.00 $5,000.00 45 Historical Museum Store Cards and More 167 Hale St. Mesa CA 90104 $5,025.75 $5,000.00 15 502 Almond ton 586 3345 Devon Ave. Almondton CA 90125 $3,456.75 $15,000.00 45 General Store Cricket Gift Shop 372 Oxford St. Grove CA 90092 $678.90 $7,500.00 30 665 S4,234,60 S10,000,000 15 Cress Store 12 Rising Sun Ave Congaree CA 90097 713 Unique Gifts 786 Passmore St. Northfield CA 90098 $124.75 $7.500.00 45 945 Gilham St. Mesa CA 90104 5.99 S15,000.00 30 Kline's 824 893 All Season Gifts 382 Wildwood Ave. Fullton CA 90085 s935.75 s7,500.00 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!