When this query is executed, the result table will contain o…
When this query is executed, 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) >=88) vendors_temp ON i.vendor_id = vendors_temp.vendor_idGROUP BY i.vendor_idORDER BY smallest_invoice;
Read Details