\set ECHO none
add_provenance

(1 row)
remove_provenance

(1 row)
region|pipeline|if_any_deal|forecast|avg_deal
North|275 (*)|155.59|154.50|68.8 (*)
South|215 (*)|125.40|124.50|53.8 (*)
West|310 (*)|130.17|126.00|77.5 (*)
(3 rows)
remove_provenance

(1 row)
region|quarter|forecast
North|Q1|94.50
North|Q2|60.00
North||154.50
South|Q1|64.50
South|Q2|60.00
South||124.50
West|Q1|63.00
West|Q2|63.00
West||126.00
||405.00
(10 rows)
remove_provenance

(1 row)
customer|region|quarter|amount|to_date|expected_to_date|pct_of_region|pct_unconditioned
Arctis|North|Q1|80|125 (*)|102.50|56.14|64.15
Borealis|North|Q1|45|125 (*)|117.00|29.17|36.08
Fjordline|North|Q2|120|275 (*)|238.50|51.69|96.23
Glacier|North|Q2|30|275 (*)|160.50|23.35|24.06
Meridian|South|Q1|60|85 (*)|82.50|47.72|65.44
Solstice|South|Q1|25|85 (*)|67.00|27.09|27.26
Tropica|South|Q2|90|215 (*)|178.50|52.76|98.15
Zenith|South|Q2|40|215 (*)|140.50|33.98|43.62
Canyon|West|Q1|70|105 (*)|98.00|50.69|77.87
Horizon|West|Q1|35|105 (*)|70.00|38.77|38.94
Mesa|West|Q2|55|310 (*)|148.00|46.26|61.19
Sierra|West|Q2|150|310 (*)|246.00|63.39|166.87
(12 rows)
remove_provenance

(1 row)
region|share
North|0.3863
South|0.3121
West|0.3015
(3 rows)
remove_provenance

(1 row)
region|p_top
North|0.4516
South|0.2790
West|0.2960
(3 rows)
remove_provenance

(1 row)
region|rk|expected_rank
North|2 (*)|1.7483
South|3 (*)|2.0830
West|1 (*)|2.1211
(3 rows)
remove_provenance

(1 row)
region|on_target|p
North|false|0.4510
North|true|0.5490
South|false|0.4212
South|true|0.5788
West|false|0.4320
West|true|0.5680
(6 rows)
remove_provenance

(1 row)
region|growth
North|-34.50
South|-4.50
West|0.00
(3 rows)
remove_provenance

(1 row)
region|p_growth
North|0.3010
South|0.5080
West|0.4400
(3 rows)
remove_provenance

(1 row)
region|big_deal|p_big
North|true (*)|0.3000
South|false (*)|0.0000
West|true (*)|0.2000
(3 rows)
remove_provenance

(1 row)
name|big_deal|p
North|f|0.7000
North|t|0.3000
South|f|1.0000
West|f|0.8000
West|t|0.2000
(5 rows)
remove_provenance

(1 row)
region|pct_big
North|49.35
South|40.03
West|30.10
(3 rows)
remove_provenance

(1 row)
best_region|average_region
194.73|135.00
(1 row)
remove_provenance

(1 row)
deals_closed|p
1|0.3637
2|0.7629
3|0.7458
4|0.2792
(4 rows)
remove_provenance

(1 row)
region|customer|amount|p
North|Fjordline|120|0.3000
North|Arctis|80|0.6300
North|Borealis|45|0.0350
North|Glacier|30|0.0280
South|Tropica|90|0.4000
South|Meridian|60|0.4200
South|Zenith|40|0.1080
South|Solstice|25|0.0648
West|Sierra|150|0.2000
West|Canyon|70|0.4000
West|Mesa|55|0.2400
West|Horizon|35|0.1280
(12 rows)
remove_provenance

(1 row)
region|sd|expected_sd
North|40.1 (*)|33.31
South|28.1 (*)|24.28
West|50.4 (*)|28.58
(3 rows)
WARNING:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks cs9_deal
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
region|label
North|275 k€
South|215 k€
West|310 k€
(3 rows)
remove_provenance

(1 row)
region|label
North|275 k€
South|215 k€
West|310 k€
(3 rows)
ERROR:  ProvSQL: aggregate result read as a plain value: provenance not tracked, although the statement tracks cs9_deal (provsql.implicit_freeze is 'error')
DETAIL:  provsql-reason: aggregate-read-as-plain-value; scope: gap; reader: operator
HINT:  Mark it plain() to say so.
remove_provenance

(1 row)
region|label
North|275 k€
South|215 k€
West|310 k€
(3 rows)
remove_provenance

(1 row)
name|purposes|unrestricted|for_marketing|conflicts|allowed
North|{analytics,marketing}|f|f|{analytics,marketing}|{}
South|{forecasting,analytics,marketing}|t|t|{}|{forecasting,analytics,marketing}
West|{}|f|f|{}|{}
(3 rows)
remove_provenance

(1 row)