Using a self-join to find duplicate emails in a users table, which query correctly returns each user row that shares its email with a different user?-- users(id, email)
