# E091-07: DISTINCT quantifier

statement ok
CREATE TABLE TABLE_E091_07_01_01 ( ID INT PRIMARY KEY, A FLOAT );

query F
SELECT AVG ( DISTINCT A ) FROM TABLE_E091_07_01_01
----
null

statement ok
CREATE TABLE TABLE_E091_07_01_02 ( ID INT PRIMARY KEY, A FLOAT );

query I
SELECT COUNT ( DISTINCT A ) FROM TABLE_E091_07_01_02
----
0

statement ok
CREATE TABLE TABLE_E091_07_01_03 ( ID INT PRIMARY KEY, A FLOAT );

query F
SELECT MAX ( DISTINCT A ) FROM TABLE_E091_07_01_03
----
null

statement ok
CREATE TABLE TABLE_E091_07_01_04 ( ID INT PRIMARY KEY, A FLOAT );

query F
SELECT MIN ( DISTINCT A ) FROM TABLE_E091_07_01_04
----
null

statement ok
CREATE TABLE TABLE_E091_07_01_05 ( ID INT PRIMARY KEY, A FLOAT );

query F
SELECT SUM ( DISTINCT A ) FROM TABLE_E091_07_01_05
----
null
