Query: identity_user_by_verified_email

with email_stat as (
  select
    case
      when email_verified then 'verified' else 'unverified'
    end as email_stat
  from
    oci_identity_user
)
  select
    email_stat,
    count(*)
  from
    email_stat
  group by
    email_stat