Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started