Databases Reporting with SQL Working with Text Replacing Strings

Andrzej Szelemetko
Andrzej Szelemetko
25,447 Points

replace(email, '@', '<at>') problems in task I am getting the following error: Bummer: Expectin

With this answer: select replace(email, '@', '<at>') from customers; I am getting the following error: Bummer: Expecting results like Lauren.Chalkley<at>example.com not Lauren.Chalkley<at>example.com.

Is this a bug in the challegne task, or am I missing something?

1 Answer

Steven Parker
Steven Parker
163,023 Points

It looks like you're missing the last instruction of the challenge: "Alias it as obfuscated_email." So you get the right results but with the wrong column name.

Add the alias and you'll pass the challenge.