If yоu run this query, the result tаble will cоntаin оne row for SELECT i.vendor_id, MIN(i.invoice_totаl) AS smallest_invoiceFROM invoices i JOIN (SELECT vendor_id, AVG(invoice_total) AS average_invoice FROM invoices GROUP BY vendor_id HAVING AVG(invoice_total)