Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- SUBSTRING(Email, CHARINDEX('@', Email) + 1, LEN(Email) - CHARINDEX('@', Email)) as [Email Provider],
- COUNT(Username) [Number Of Users]
- from Users
- group by SUBSTRING(Email, CHARINDEX('@', Email) + 1, LEN(Email) - CHARINDEX('@', Email))
- order by COUNT(Username) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement