| procedure type | kibs class | n | avg planned value eur | median planned value eur |
|---|---|---|---|---|
|
Atklāts konkurss
|
non_kibs
|
219
|
263918
|
121983
|
|
Mazie iepirkumi
|
non_kibs
|
179
|
36290
|
41983
|
|
Mazie iepirkumi
|
strict_kibs
|
135
|
34813
|
4.05e4
|
|
Atklāts konkurss
|
weak_signal
|
129
|
380101
|
1.32e5
|
|
Atklāts konkurss
|
strict_kibs
|
112
|
224331
|
103680
|
|
Atklāts konkurss
|
possible_kibs
|
59
|
2.0825e6
|
3.5e5
|
|
Mazie iepirkumi
|
weak_signal
|
47
|
35484
|
41999
|
|
Mazie iepirkumi
|
possible_kibs
|
33
|
45716
|
41999
|
SELECT
proceduras_veids AS procedure_type,
kibs_text_class AS kibs_class,
count(*) AS n,
round(avg(try_cast(planota_ligumcena AS DOUBLE)), 0) AS avg_planned_value_eur,
round(median(try_cast(planota_ligumcena AS DOUBLE)), 0) AS median_planned_value_eur
FROM xlsx_gold_standard_v12_b56445cb_4
GROUP BY 1, 2
ORDER BY n DESC