"""Get a report of UPC's, and their asset count, and aggregate file size."""
GET_RELEASE_SIZES = """
SELECT
  VENDOR_ID,
  ORCH_UPC,
  count(ORCH_UPC) AS asset_count,
  sum(FILE_SIZE)/1024/1024 AS release_size_mb
FROM
  {catalog}.{schema}.{source_table}
GROUP BY
  1,
  2
ORDER BY
  3 ASC
;
"""