📧 One Person, Two Accounts — A Compliance Problem.
The trust and safety team at Airbnb discovered that some users registered multiple accounts with the same email address — violating platform policy and potentially enabling fraud.
Find all email addresses that appear more than once in the users table. Return email and account_count. Order by account_count descending.
users Table:
| Column | Type |
|---|---|
| user_id | integer |
| full_name | text |
| text | |
| created_at | text |
Expected Outcome (Illustrative Sample):
| account_count | |
|---|---|
| alice@gmail.com | 3 |