Which partitioned tables have no partition expiration set?

-- Partitioned tables lacking partition_expiration_days, in every dataset
-- of the region: COLUMNS and TABLE_OPTIONS take a region qualifier as well
-- as a dataset one.
WITH partitioned AS (
  SELECT DISTINCT table_schema, table_name
  FROM `region-us`.INFORMATION_SCHEMA.COLUMNS
  WHERE is_partitioning_column = 'YES'
),
expiring AS (
  SELECT DISTINCT table_schema, table_name
  FROM `region-us`.INFORMATION_SCHEMA.TABLE_OPTIONS
  WHERE option_name = 'partition_expiration_days'
)
SELECT
  p.table_schema,
  p.table_name,
  ROUND(s.total_logical_bytes / POW(1024, 3), 2)             AS logical_gib,
  s.total_partitions
FROM partitioned p
LEFT JOIN expiring e USING (table_schema, table_name)
LEFT JOIN `region-us`.INFORMATION_SCHEMA.TABLE_STORAGE s
       USING (table_schema, table_name)
WHERE e.table_name IS NULL
ORDER BY s.total_logical_bytes DESC;