\set ECHO none
remove_provenance

(1 row)
city|count
Berlin|1 (*)
New York|2 (*)
Paris|3 (*)
(3 rows)
city|aggregation_formula
Berlin|(Ellen ⊕ Susan)*1
New York|John*1+Paul*1
Paris|Dave*1+Magdalen*1+Nancy*1
(3 rows)
remove_provenance

(1 row)
city|count|count_name|count_class
Berlin|2 (*)|2 (*)|1 (*)
New York|2 (*)|2 (*)|2 (*)
Paris|3 (*)|3 (*)|3 (*)
(3 rows)
city|count_name|count_class
Berlin|Ellen*1+Susan*1|(Ellen ⊕ Susan)*1
New York|John*1+Paul*1|John*1+Paul*1
Paris|Dave*1+Magdalen*1+Nancy*1|Dave*1+Magdalen*1+Nancy*1
(3 rows)
remove_provenance

(1 row)
city|cnt|counting
Berlin|2 (*)|1
New York|2 (*)|1
Paris|3 (*)|1
(3 rows)