When the following query is executed, the result set will include one row for each invoice with an invoice total that's greater than SELECT vendor_name, invoice_number, invoice_total FROM vendors JOIN invoices ON vendors. vendor_id = invoices. vendor_id WHERE invoice_total > ANY (SELECT invoice_total FROM invoices WHERE vendor_state = 'CA') the minimum invoice total for vendors in California the maximum invoice total for vendors in California the minimum invoice total for vendors in states other than California the maximum invoice total for vendors in states other than California