Count of invoices for each vendor (invoice_count) Sum of invoice total values by vendor (invoice_total_count) Average invoice_total amount for each vendor Rent and her to Export Wrap Oil Contact vendor nane invoice_count Invoice_total_sun Invoice average Federal Express Corporation 47 $ 4,378.02 $ 93.15 United Parcel Service 9 $ 23,177.96 $ 2,575.33 zyika Design 8 $ 6,948.25 $ 867.53 Pacific Bell 6 $ 171.01 $28.50 Malloy Lithographing Inc 5 $ 119,892,41 $ 23,978,48 Roadway Package Systen, Inc 4 $ 43.67 $ 10.92 Blue Cross 3 $ 564.00 $ 188.00 Compuserve 2 $ 19.90 $9.95 IBM 2 $ 1.200.12 $ 600.06 Cardinal Business Media, Inc. 2 $265.36 $ 132,68 Data Reproductions Corp 2 $ 21,927.31 $ 10,963.66 Ingran 2 $ 2,154.42 $ 1,077.21 Fresno County Tax Collector 1 $ 856.92 $ 856.92 Dristas Groon & McCornick 1 $ 220.00 $ 220.00 Bertelsmann Industry Sves. Inc 1 $ 6,940.25 $ 5,940.25 Reiter's Scientific & Pro 5... 1 $ 600.00 $ 600.00 Franchise Tax Board 1 $ 1,600.ee $ 1.600.60 2 pts Question 3 Write a SELECT statement that returns the same result set as the SELECT statement below, but don't use a join Instead, use a subquery, in a WHERE clause that uses the IN keyword. SELECT DISTINCT vendor_name FROM vendors v JOIN invoices i USING (vendor_id) ORDER BY vendor_name