| procedure type | n tenders | n single bidder | pct single bidder | avg bids | avg days to prepare | avg price weight |
|---|---|---|---|---|---|---|
|
Atklāts konkurss
|
14
|
0
|
0
|
8.21
|
22.5
|
100
|
|
Mazie iepirkumi
|
14
|
|
|
2.57
|
16.6
|
|
|
|
1
|
|
|
|
|
|
SELECT
procedure_type,
count(*) AS n_tenders,
sum(try_cast(single_bidder AS INTEGER)) AS n_single_bidder,
round(100.0 * sum(try_cast(single_bidder AS INTEGER)) / count(*), 1) AS pct_single_bidder,
round(avg(try_cast(total_bids AS DOUBLE)), 2) AS avg_bids,
round(avg(try_cast(days_to_prepare AS DOUBLE)), 1) AS avg_days_to_prepare,
round(avg(try_cast(price_weight AS DOUBLE)), 1) AS avg_price_weight
FROM xlsx_inventory_v3_4b022d33_1
GROUP BY 1
ORDER BY n_tenders DESC