Write a query that selects the following data for each vendor in invoices from these tables: invoices, vendors, general_ledger_accounts and terms

Vendor Name, City and State as one column in this format "Dwayne's Warehouse - Cleveland, Ohio" The largest invoice amount The smallest invoice amount The average invoice amount The median invoice amount (half way between min and max) The date of the oldest invoice in the format December 25, 2019 The default terms or net days due, as a number of days, not the description The description of the default account The average number of days it took to pay a invoice (invoice_date to payment_date) rounded to the nearest integer

Only include paid invoices Order by Vendor Name Invoice amounts should be formated with dollar signs, two decimal places and commas for thousands