all users with one verified and multiple unverified accounts

verified.sql

SELECT  
        count("email") AS "count", 
        count("verifiedemail") as "Verified", 
        max("createdAt") as "Last Attempt", 
        min("createdAt") as "First Attempt", 
        "public"."users"."email" AS "email"
FROM "public"."users"
GROUP BY "public"."users"."email"
HAVING 
        count("email") > 1 AND 
        count("verifiedemail") = 1
ORDER BY "count" DESC, "public"."users"."email" ASC