Business case: the accounting department would like a report showing all vendor invoices that are less than that vendor’s largest invoice. specifically the companyid, invoice number, date and total. write a select statement that returns 4 columns: vendorid, invoicenumber, invoicedate and invoicetotal. filter the results to only return records where the invoicetotal is less than the result(s) of the query. subquery portion: *select the largest invoicetotal for each vendor. sort the results by vendorid and invoicetotal\.\*you will need to alias both the outer query and subquery tables. within the subquery, you will need to filter the results where the vendorid’s are equal in both correlated tables.