\set ECHO none
NOTICE:  table "hcd_t" does not exist, skipping
add_provenance

(1 row)
remove_provenance

(1 row)
shape|g|p
count(distinct) >= 2|1|0.6250
count(distinct) >= 2|2|0.2500
(2 rows)
remove_provenance

(1 row)
shape|g|p
count(distinct) >= 3|1|0.1875
count(distinct) >= 3|2|0.0000
(2 rows)
remove_provenance

(1 row)
shape|g|p
count(distinct) = 2|1|0.4375
count(distinct) = 2|2|0.2500
(2 rows)
remove_provenance

(1 row)
shape|g|p
count(distinct) <= 1|1|0.3125
count(distinct) <= 1|2|0.5000
(2 rows)
remove_provenance

(1 row)
shape|g|cd|p
select+having|1|3 (*)|0.6250
select+having|2|2 (*)|0.2500
(2 rows)
remove_provenance

(1 row)
remove_provenance

(1 row)
shape|g|p_off|p_on|diff
off vs on|1|0.6250|0.6250|0.000000
off vs on|2|0.2500|0.2500|0.000000
(2 rows)
add_provenance

(1 row)
add_provenance

(1 row)
remove_provenance

(1 row)
shape|g|c
lj count|1|1 (*)
lj count|2|1 (*)
lj count|3|2 (*)
(3 rows)
remove_provenance

(1 row)
shape|g|p
lj having|1|1.0000
lj having|2|1.0000
lj having|3|0.7500
(3 rows)