\set ECHO none
remove_provenance

(1 row)
position|count|formula
Analyst|2 (*)|δ(Dave ⊕ Susan)
Director|1 (*)|δ(John)
Double agent|1 (*)|δ(Magdalen)
Field agent|1 (*)|δ(Ellen)
HR|1 (*)|δ(Nancy)
Janitor|1 (*)|δ(Paul)
(6 rows)
position|aggregation_formula
Analyst|sum{ (1 * Susan) , (1 * Dave) }
Director|sum{ (1 * John) }
Double agent|sum{ (1 * Magdalen) }
Field agent|sum{ (1 * Ellen) }
HR|sum{ (1 * Nancy) }
Janitor|sum{ (1 * Paul) }
(6 rows)
remove_provenance

(1 row)
position|aggregation_formula
Director|sum{ (1 * John) }
Double agent|sum{ (1 * Magdalen) }
Field agent|sum{ (1 * Ellen) }
HR|sum{ (1 * Nancy) }
Janitor|sum{ (1 * Paul) }
(5 rows)
remove_provenance

(1 row)
position|aggregation_formula
Director|sum{ (1 * John) }
Double agent|sum{ (1 * Magdalen) }
Field agent|sum{ (1 * Ellen) }
HR|sum{ (1 * Nancy) }
Janitor|sum{ (1 * Paul) }
(5 rows)