Users per Email Domain

Count how many users belong to each email domain (the part after '@'). Return domain and user_count, ordered by user_count descending then domain.

Table schema

Users(id INT PRIMARY KEY, email VARCHAR(100))

Sample data

id | email
1 | john@gmail.com
2 | sara@yahoo.com
3 | mike@gmail.com