Example of output from the last Query

SELECT vendor_name, invoice_number, invoice_total

FROM invoices i JOIN vendors v ON i.vendor_id = v.vendor_id

WHERE invoice_total > ALL

(SELECT invoice_total

FROM invoices

WHERE vendor_id = 34)

ORDER BY vendor_name

Subquery Result

Overall Results