select i.vendor id, max(i.invoice total) as largest invoice from invoices i join (select vendor id, avg(invoice total) as average invoice from invoices group by vendor id having avg(invoice total) > 100 order by average invoice desc) ia on i.vendor id