sql正则表达式查询用法？

table
id email aa bb
101 ####@qq.com 1 2
102 wwwww@qq.com 2 3
103 werwerwer@163.com 3 3
104 sdfsdfs@sina.com 3 2

要实现
域名 sum(aa) sum(bb)
qq.com 3 5
sina.com 3 2
163.com 3 3

select domain = substring(email, charindex('@',email), len(email))
, aa = sum(aa), bb = sum(bb)
from [table]
group by substring(email, charindex('@',email), len(email))

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息