Cognizant SQL Interview Question | Extract the Domain from the Email Column in Employee Table

[@monasanthosh9208]

Select *,concat(replace(Name," ","."),"@",domins) as email from domin;

[@rohitconnect]

RIGHT(email,(len(email)-locate('@',domain))) should this work as well?
i dont have Sever to test

[@datasciencecorner]

Will check and let you know