complete the SQL study questions..2 pictures

When coding a query with two columns in the GROUP BY clause, you can insert a summary row for each major group by coding which operator? 1) OVER - 2) ROLLUP 3) HAVING 4) none of the above Question 6 (1 point) Saved Which functions perform a calculation on the values of a column from selected rows? 1) Arithmetic 2) String 3) Summary - 4) Aggregate Question 7 (1 point) Saved Write an aggregate expression for the number of unique values in the VendorlD column 1) AVG(VendorID) 2) COUNT(VendorlD) 3) SUM(VendorID) 4) COUNT DISTINCT VendorID) Question 8 (1 point) Savd All of the aggregate functions ignore null values, except for which function? Which of the statements below best describes the result set returned by this SELECT statement? SE LECT VendorState, COUNT ) AS Column2 FROM Vendora GROUP BY Vendorstate HAVING COUNT>1; 1) The names of the vendors in each state 2) The duplicate vendors from each state 3) The number of vendors in each state 4) The number of vendors in each state having more than one vendor Question 10 (1 point) Saved Write an aggregate expression for the number of entries in the VendorName column, including null values - 1) COUNT(Invoice + Null) 2) SUM(VendorName) 3) COUNTIVendorName) 4) COUNT)