Scripts

2. Declare a table variable called "Vendory". In that table, Insert the following data which should be generated with a query that joins the Vendors & Involces tables with aggregate functions and group by, where county is the number of Involces of each vendor and total is the PaymentTotal of each vendor. Refer to lecture WK3-Ch14-scripts(2) Slide#3. Then write a select query to display the data from the Vendory table variable to look like the following table. Some numbers in the total column may not match with yours. vname Federal Express Corporation United Parcel Service Zylka Design Pacific Bell Malloy Lithographing Inc Roadway Package System, Inc Blue Cross Cardinal Business Media, Inc Compuserve Data Reproductions com IBM Ingram county total 47 4167.13 9 23177.96 8 6740.25 6 171.01 5 86069.22 4 43.67 3 340.00 2 125.00 2 19.90 2 2.1842.00 2 1200.12 2 1575.00 2. Declare a table variable called "Vendory". In that table, Insert the following data which should be generated with a query that joins the Vendors & Invoices tables with aggregate functions and group by, where county is the number of invoices of each vendor and total is the paymentTotal of each vendor. Refer to lecture WK3-Ch14-scripts(2) Slide3. Then write a select query to display the data from the Vendory table variable to look like the following table. Some numbers in the total column may not match with yours