If you run this query, the result table will contain one row…

If you run this query, the result table will contain one row for SELECT i.vendor_id, MIN(i.invoice_total) 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)