Aggregation Functions
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What do aggregation functions do?
2. Instead of listing every employee's salary, what might an aggregation function be used to obtain?
3. Which SQL aggregation function counts the number of rows in a result set?
4. Which SQL function computes the mean of values in a numeric column?
5. What does the SQL GROUP BY clause do?
6. What is the role of HAVING in a SQL query?
7. What does SELECT DISTINCT department FROM employees; return?
8. Which query returns the lowest salary in the employees table?
9. What is described as the ultimate purpose of using aggregation functions?
10. Which of the following is NOT one of the common SQL aggregation-related functions and clauses listed?