This question asked in interview and even i don't know its possible or not.
i need query to generate email for employees like
ename starts with 'S' then firstname.lastname@example.org
ename starts with 'A' then Amit@yahoo.com
ename starts with 'C' then email@example.com
ename starts with 'M' then firstname.lastname@example.org
explanation:- if name of employee starts with character 'S' then email@example.com
if name of employee is starts with 'M' then
firstname.lastname@example.org etc like this for ename 'c' email@example.com
depending upon 1st character of ename we to give domain name.