Query: dynamodb_table_unused_status

with table_status as (
  select
    name,
    case
      when item_count > 0 then 'in-use'
      else 'unused'
    end as table_usage_status
  from
    aws_dynamodb_table
)
select
  table_usage_status,
  count(*) as table_count
from
  table_status
group by
  table_usage_status;