This preview shows page 1. Sign up to view the full content.
Unformatted text preview: List the salespeople whose average order size for products manufactured by XYZ is higher than overall average order size. select name, avg(amount) from salesreps, orders where empl_num = rep and mfr = 'XYZ' group by name having avg(amount) > (select avg(amount) from orders)...
View Full Document
- Spring '09