SQL quiz. Given the Students table: <pre><code>+-----+------

Given the Students table:

+-----+-----------+-------+
| SId | FirstName | Score |
+-----+-----------+-------+
|   1 | Kate      |  100  |
|   2 | Misha     |    0  |
|   3 | Nick      | NULL  |
|   4 | Larisa    |  200  |
|   5 | Misha     |  150  |
|   6 | Larisa    |   50  |
|   7 | Misha     |   50  |
|   8 | Kate      |  100  |
+-----+-----------+-------+

What is the result of the following query:

SELECT MAX(SUM(Score))
FROM Students
GROUP BY FirstName;

100
200
250
Query will not return value because of NULL value in a table
Query will not be executed because of a syntax error

Explanation

Aggregate functions cannot take other aggregate functions as inputs. Given query has to be rewritten in the following way:

SELECT MAX(score_sum) FROM
(SELECT SUM(Score) as score_sum
FROM Students
GROUP BY FirstName);

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback