Query: efs_file_system_by_encryption_status

select
  encryption_status,
  count(*)
from
  (
    select
      case
        when encrypted then 'Encrypted'
        else 'Not Encrypted'
      end encryption_status
    from
      aws_efs_file_system
  ) as t
group by
  encryption_status
order by
  encryption_status;