email generator by sql

Question

You need to generate emails for the Employees.

The email format is [e-mail]

So, for example, for John Smith the email would be: [e-mail]

Note, that the email should be in lowercase.

Write a query to create the email addresses for all employees in the table and output the result in a new column called "email".

Answer 1

If I recall correctly, it is the exercise from SQL Intermediate > Data Manipulations > String Functions.

From the lesson takeaways, it already summarized everything in the lesson for you.
- CONCAT is used to combine multiple strings into one column.
- LOWER and UPPER convert the text to lowercase and uppercase
- SUBSTRING is used to extract a part of the text.
- REPLACE is used to replace one value with another in the text.

Most noticeable is the CONCAT and LOWER function, since you need to combine text and the result should be in lowercase.
Also, you need to sort the result as required, which you should learn earlier.

Answer 2

That's a cool task. Have you done it yet? Having troubles? (We're not a code writing service)
Help us to help you, read and do the following:

https://sololearn.com/compiler-playground/Wek0V1MyIR2r/?ref=app
https://sololearn.com/compiler-playground/WZ8lkR6gTex6/?ref=app
https://sololearn.com/compiler-playground/W0uW3Wks8UBk/?ref=app