WITH docs AS (
  SELECT
    procurement_id AS tender_id,
    count(*) AS n_files,
    count(DISTINCT lower(file_type)) AS n_file_types,
    sum(try_cast(bytes AS BIGINT)) AS total_bytes,
    string_agg(DISTINCT lower(file_type), ', ' ORDER BY lower(file_type)) AS file_types
  FROM xlsx_inventory_v3_4b022d33_2
  GROUP BY procurement_id
), tenders AS (
  SELECT
    tender_id,
    procedure_type,
    try_cast(days_to_prepare AS DOUBLE) AS days_to_prepare,
    try_cast(total_bids AS DOUBLE) AS total_bids,
    try_cast(award_amount AS DOUBLE) AS award_amount
  FROM xlsx_inventory_v3_4b022d33_5
)
SELECT
  t.tender_id,
  t.procedure_type,
  t.days_to_prepare,
  t.total_bids,
  d.n_files,
  d.n_file_types,
  round(d.total_bytes / 1000000.0, 2) AS mb_files,
  d.file_types
FROM tenders t
LEFT JOIN docs d USING (tender_id)
ORDER BY d.n_files DESC NULLS LAST, t.total_bids ASC;