Query: lambda_function_uses_latest_runtime_status

select
  runtime_status,
  count(*)
from
  (
    select
      case
        when runtime not in (
          'nodejs14.x',
          'nodejs12.x',
          'nodejs10.x',
          'python3.8',
          'python3.7',
          'python3.6',
          'ruby2.5',
          'ruby2.7',
          'java11',
          'java8',
          'go1.x',
          'dotnetcore2.1',
          'dotnetcore3.1'
        ) then 'previous'
        else 'latest'
      end runtime_status
    from
      aws_lambda_function
  ) as t
group by
  runtime_status
order by
  runtime_status desc;