bq009.sql

  SELECT
    file.project_short_name,
    file.data_category,
    file.data_type,
    file.data_format,
    COUNT(file.file_gdc_id) as n
  FROM
    `isb-cgc-bq.GDC_case_file_metadata.fileData_active_current` AS file
  WHERE
    associated_entities__case_gdc_id IN ('{case_ids}')
  GROUP BY
    file.project_short_name,
    file.data_category,
    file.data_type,
    file.data_format
  ORDER BY file.data_type, n DESC