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

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 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

Explanation / Answer

This query will retrieve the avg balance of the customer according to the representative along with the representative firstname and lastname combined as single value Fullname;

Inorder to combine the two columns we have to use || symbol. this will combine the two column values into single value in output.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.