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" 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
Get step-by-step solutions from verified subject matter experts
