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;