\set ECHO none
remove_provenance

(1 row)
position|scaled_count
Analyst|20 (*)
Director|10 (*)
Double agent|10 (*)
Field agent|10 (*)
HR|10 (*)
Janitor|10 (*)
(6 rows)
remove_provenance

(1 row)
position|half_count
Analyst|1.00000000000000000000 (*)
Director|0.50000000000000000000 (*)
Double agent|0.50000000000000000000 (*)
Field agent|0.50000000000000000000 (*)
HR|0.50000000000000000000 (*)
Janitor|0.50000000000000000000 (*)
(6 rows)
remove_provenance

(1 row)
position|offset_count
Analyst|102 (*)
Director|101 (*)
Double agent|101 (*)
Field agent|101 (*)
HR|101 (*)
Janitor|101 (*)
(6 rows)
remove_provenance

(1 row)
doubled_avg
8.0000000000000000 (*)
(1 row)
remove_provenance

(1 row)
position|sum_plus_one
Analyst|11 (*)
Director|2 (*)
Double agent|6 (*)
Field agent|5 (*)
HR|7 (*)
Janitor|3 (*)
(6 rows)
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
remove_provenance

(1 row)
city|cnt_numeric
Berlin|2
New York|2
Paris|3
(3 rows)
remove_provenance

(1 row)
city|plus_one
Berlin|3 (*)
New York|3 (*)
Paris|4 (*)
(3 rows)
WARNING:  ProvSQL: window functions are not supported; provenance is tracked per input row only, and the windowed computation is treated as an opaque scalar
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
remove_provenance

(1 row)
city|cnt|total
Berlin|2 (*)|7
New York|2 (*)|7
Paris|3 (*)|7
(3 rows)
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
remove_provenance

(1 row)
city|cnt
Berlin|2
New York|2
Paris|3
(3 rows)
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
WARNING:  ProvSQL: converting agg_token to bigint: provenance information is lost
remove_provenance

(1 row)
city|at_least_3
Berlin|3
New York|3
Paris|3
(3 rows)
remove_provenance

(1 row)
city|doubled
Berlin|11.0000000000000000 (*)
New York|3.0000000000000000 (*)
Paris|9.3333333333333334 (*)
(3 rows)
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
WARNING:  ProvSQL: converting agg_token to text: provenance information is lost
remove_provenance

(1 row)
city|team
Berlin|Ellen, Susan (team)
New York|John, Paul (team)
Paris|Dave, Magdalen, Nancy (team)
(3 rows)
remove_provenance

(1 row)
disp
11.0 (*)
12.0 (*)
6.0 (*)
(3 rows)