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
- MYSQL , PostgreSQL, Microsoft SQL Server, Articles with example SQL code