SQL Query Question: Need to figure out how to count and filter?

This would depend on what DBMS you use, since string manipulation functions are extensions to standard SQL and differ between DBMSs. For example, in Oracle you could extract the domain from an email column using a combination of the INSTR (to locate @) and RTRIM (to extract the remaining text) functions.