SQL SERVER||How to get Domain Name and count of emails using CASE Statement?

select Domain_Name,Count(*) AS Total_Domain_Names From (
select Email_Name,CASE WHEN Email_Name like '%gmail%' THEN 'gmail'
WHEN Email_Name like '%yahoo%' THEN 'yahoo'
else 'outlook'
End AS Domain_Name
from email)Result Group By Domain_Name Order By 2 desc

Видео SQL SERVER||How to get Domain Name and count of emails using CASE Statement? канала SQLtoSSIStoPowerBI