Email address verification in sql

I have user events table. I am trying to come with count of different email addresses they logged in in SQL. In this case I have to ignore same patterns.Can someone please help me on this.

2. userid element value
3. 111 email georgegmail.com
4. 111 email geo gegmail.com
5. 111 email ge ogegmail.com
6. 111 email ge orgeggmail.com

7. 111 email george_roseggmail.com

   o/p: 111 email 2