Quiz Yourself: Grouping and Aggregation
Test your knowledge of grouping and aggregate functions.
We'll cover the following...
We'll cover the following...
Grouping and Aggregation Quiz
1.
Consider the following Grades table.
| StudentId | Grade |
|---|---|
| 1 | 79 |
| 2 | 84 |
| 3 | 74 |
| 4 | 82 |
| 5 | 68 |
| 6 | 77 |
(Select all that apply.) We want to output the second lowest grade. Which option(s) can we use? Multi-select
A.
SELECT MIN(Grade) FROM Grades;
B.
SELECT Grade FROM Grades
WHERE Grade = 74;
C.
SELECT MIN(Grade) FROM Grades
WHERE Grade <> 68;
D.
SELECT MIN(Grade) FROM Grades
WHERE Grade > 68;
1 / 6
...