Use SQL and TAL Distributors database to complete the following questions

1. For each customer, list the customer number, rep number, and the average balance of the reps customers. Group by rep number.

REP REP_NUM LAST NAME FIRST NAME STREET $15 Campos Rafael 30 Gradey Megan. 45 Tian Huri 60 Sefton Janet CUSTOMER CUSTOMER NUM CUSTOMER_NAME 126) Toys Galore 260 Brookings Direct 334 The Everything Shop 386 Johnson's Department Store 440 Grove Historical Museum Store 502 Cards and More -586 Almondton General Store 665 Cricket Gift Shop 713 Cress Store 796 ique Gifts 824 Kline's 893 All Season Gifts CITY 724 Vinca Dr. Grove 632 Liatris St. Fullton 1785 Tyler Ave, Northfield 267 Oakley St Congaree STREET CITY 28 Laketon St. Fullton 452 Columbus Dr. Grove 342 Magee St. 124 Main St. 3456 Central Ave. Fullton 167 Hale St. 3345 Devon Ave. 372 Oxford St. 12 Rising Sun Ave. 786 Passmore St. 945 Gilham St. Mesa 382 Wildwood Ave. Fullton STATE POSTAL CODE COMMISSION RATE CA 90092 $23,457.50 20.06 CA 90085 $41,317.00 0.08 CA 90098. $27,789.25 0.06 $0.00 0.06 CA 90097 STATE POSTAL CODE BALANCE CREDIT LIMIT REP NUM CA 90085 $1,210.25 $7,500.00 15 CA 90092 $575.00 $10,000.00 30 Congaree CA 20097 $2,345.75 $7,500.00 45 Northfield CA 90098 $879.25 $7,500.00 30 CA 90085 $345.00 $5,000.00 45 CA $5,025.75 $5,000.00 15 Mesa Almondton CA 90104 184 90125 $3,456.75 $15,000.00 45 Grove 90092 $678.90 $7,500.00 30 CA Congaree CA 90097 Northfield CA 90098 $4,234.60 $10,000.00 15: $124.75 $7,500.00 45 CA 90104 $2,475.99 $15,000.00 30 CA 90085 $935.75 $7,500.00 15