SUB-QUERY : find the names and numbers of salesperson who have more than 1 customer.

Find all the orders with above-average amounts for their customers.

(E.g. if a customer has 3 orders,then find the avg. amount of 3 orders for that customer,then out of this 3 records for this customer,select that record who amount is greater than the average amount found earlier.)