| procedure type | tenders | avg days to prepare | median days to prepare | avg total bids | median total bids | single bid tenders | avg award amount |
|---|---|---|---|---|---|---|---|
|
Atklāts konkurss
|
14
|
22.5
|
19
|
8.21
|
3.5
|
2
|
28873672
|
|
Mazie iepirkumi
|
14
|
16.6
|
15
|
2.57
|
2
|
4
|
27770
|
SELECT
procedure_type,
count(*) AS tenders,
round(avg(try_cast(days_to_prepare AS DOUBLE)), 1) AS avg_days_to_prepare,
median(try_cast(days_to_prepare AS DOUBLE)) AS median_days_to_prepare,
round(avg(try_cast(total_bids AS DOUBLE)), 2) AS avg_total_bids,
median(try_cast(total_bids AS DOUBLE)) AS median_total_bids,
sum(CASE WHEN try_cast(total_bids AS INT)=1 THEN 1 ELSE 0 END) AS single_bid_tenders,
round(avg(try_cast(award_amount AS DOUBLE)), 0) AS avg_award_amount
FROM xlsx_inventory_v3_4b022d33_5
GROUP BY 1
ORDER BY tenders DESC;