email and name filtering in sql

PHOTO EMBED

Wed Apr 06 2022 02:02:22 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

---email filtering
select name, split_part(name,' ',1) as firstname, split_part(name,' ',2) as lastname,
left(email,position('@' in email)-1) as emailname,
substring(email from position('@' in email)+1 for char_length(email))
from pizza_runner.tes as t
content_copyCOPY