\set ECHO none
remove_provenance

(1 row)
city|n|counting
|7 (*)|1
Berlin|2 (*)|1
New York|2 (*)|1
Paris|3 (*)|1
(4 rows)
remove_provenance

(1 row)
city|classification|n|g
Berlin|secret|2 (*)|0
Berlin||2 (*)|1
New York||2 (*)|1
Paris||3 (*)|1
||7 (*)|3
(5 rows)
remove_provenance

(1 row)
rows|total
17|1
(1 row)
remove_provenance

(1 row)
n
0 (*)
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
city|n|p
|0|1
(1 row)
remove_provenance

(1 row)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
DETAIL:  provsql-reason: stored-agg-token-conversion; scope: deliberate
n|k|p
5|7|1
(1 row)
remove_provenance

(1 row)
city|g|r
Berlin|0|1 (*)
New York|0|2 (*)
Paris|0|3 (*)
|1|1 (*)
(4 rows)
city|g|r
Berlin|0|1
New York|0|2
Paris|0|3
|1|1
(4 rows)