Google's trust and safety team wants to audit for duplicate email accounts. (Duplicate emails could mean either a bug in the signup flow, where two users registered with the same email. Not good!) Using the users table, find every email address that appears more than once.
Return email, ordered alphabetically.
users
| column | type |
|---|---|
| id | INTEGER |
| TEXT |
| id | |
|---|---|
| 1 | alice@example.com |
| 2 | bob@example.com |
| 3 | alice@example.com |
| 4 | carol@example.com |
| 5 | bob@example.com |
| alice@example.com |
| bob@example.com |