Big Data Systems HPI

Quiz 0 Distributed Systems


Question

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


Answer

NULL,NULL,0,1,1,2,5,6




Comments