select SUBSTRING(EmailAddress,1,CHARINDEX('@',EmailAddress,1)-1) as [Email Address without domain],SUBSTRING(EmailAddress,CHARINDEX('@',EmailAddress,1)+1,len ...
It is a SQL practice repository covering basics to advanced topics. It includes exercises on SELECT statements, WHERE clauses, GROUP BY, JOINS, window functions (OVER(), PARTITION BY), ROW_NUMBER(), ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback