Imagine there is a relation
PMoney(name:string, amount:integer)
and the SQL-Query
SELECT COUNT(*),COUNT(DISTINCT amount),
MIN(amount), MAX(amount), SUM(amount),
SUM(DISTINCT amount), AVG(amount),
(VARIANCE(amount) + POWER(AVG(amount),2)) * COUNT(amount) AS 'E(X^2)'
FROM PMoney
that results in
COUNT(*) | COUNT(DISTINCT amount) | MIN(amount) | MAX(amount) | SUM(amount) | SUM(DISTINCT amount) | AVG(amount) | E(X^2) |
---|---|---|---|---|---|---|---|
8 | 5 | 0 | 6 | 15 | 14 | 2.5000 | 67 |
What is the result of the Query?
SELECT amount
FROM PMoney
ORDER BY PMoney.amount ASC
Enter the values in a comma separated list and use
NULL
for NULL values, e.g.,
NULL,A,B,C
Don't use spaces between the elements, e.g,
A, B, C, NULL