LOAD 'pg_diffix';

SET pg_diffix.noise_layer_sd = 7;

SET pg_diffix.low_count_layer_sd = 2;

SET pg_diffix.low_count_min_threshold = 2;

SET ROLE diffix_test;

SET pg_diffix.session_access_level = 'anonymized_trusted';

SELECT diffix.access_level();

SELECT COUNT(*) FROM test_customers;

SELECT COUNT(*) FROM test_purchases;

SELECT COUNT(city), COUNT(DISTINCT city) FROM test_customers;

SELECT COUNT(DISTINCT cid) FROM test_purchases;

SELECT city, COUNT(DISTINCT id) FROM test_customers GROUP BY 1;

SELECT COUNT(*) FROM test_customers WHERE planet = 'Earth';

SELECT SUM(id), diffix.sum_noise(id) FROM test_customers;

SELECT SUM(discount), diffix.sum_noise(discount) FROM test_customers;

SELECT city, SUM(id), diffix.sum_noise(id) FROM test_customers GROUP BY 1;

SELECT city, SUM(discount), diffix.sum_noise(discount) FROM test_customers GROUP BY 1;

SELECT city, AVG(discount), diffix.avg_noise(discount) FROM test_customers GROUP BY 1

EXCEPT

SELECT city, SUM(discount) / COUNT(discount), diffix.sum_noise(discount) / COUNT(discount) FROM test_customers GROUP BY 1;

SELECT city, AVG(id), diffix.avg_noise(id) FROM test_customers GROUP BY 1

EXCEPT

SELECT city, SUM(id)::float8 / COUNT(id), diffix.sum_noise(id) / COUNT(id) FROM test_customers GROUP BY 1;

SELECT diffix.count_noise(*), diffix.count_noise(city), diffix.count_noise(DISTINCT city) FROM test_customers;

SELECT 1 FROM test_patients;

SELECT cast(1 as real) FROM test_patients;

SELECT 1, COUNT(*) FROM test_patients;

SELECT 1, city FROM test_customers;

SELECT city, 'aaaa' FROM test_customers;

SELECT city FROM test_patients GROUP BY 1;

SELECT COUNT(*), COUNT(city), COUNT(DISTINCT city) FROM test_patients;

SELECT city FROM test_customers;

SELECT city FROM test_customers GROUP BY 1 HAVING length(city) <> 4;

SELECT COUNT(*), COUNT(city), COUNT(DISTINCT city) FROM test_customers WHERE city = 'London';

SELECT diffix.floor_by(age, 30), COUNT(*) FROM test_patients GROUP BY 1;

SELECT diffix.floor_by(age, 30), diffix.floor_by(age, 106), COUNT(*) FROM test_patients GROUP BY 1, 2;

SELECT COUNT(*), COUNT(city), COUNT(DISTINCT city) FROM empty_test_customers;

(SELECT count(*) FROM test_customers GROUP BY city HAVING city = 'Berlin')

(SELECT count(*) FROM test_customers WHERE city = 'Berlin');

(SELECT count(*) FROM test_customers GROUP BY city, diffix.round_by(discount, 2)

HAVING city = 'Berlin' AND diffix.round_by(discount, 2) = 0)

(SELECT count(*) FROM test_customers WHERE city = 'Berlin' AND diffix.round_by(discount, 2) = 0);

(SELECT count(*) FROM test_customers WHERE diffix.round_by(discount, 2) = 0 GROUP BY city HAVING city = 'Berlin')

(SELECT count(*) FROM test_customers WHERE city = 'Berlin' AND diffix.round_by(discount, 2) = 0);

(SELECT COUNT(*) FROM test_customers AS c JOIN test_purchases ON c.id = cid WHERE city = 'Berlin')

(SELECT COUNT(*) FROM test_purchases JOIN test_customers AS c ON cid = c.id WHERE city = 'Berlin');