0

email generator by sql

You need to generate emails for the Employees. The email format is firstname.lastname@company.com So, for example, for John Smith the email would be: john.smith@company.com 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".

25th Jun 2024, 6:59 AM
Arooj Amina
Arooj Amina - avatar
2 Antworten
+ 4
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.
25th Jun 2024, 12:39 PM
Wong Hei Ming
Wong Hei Ming - avatar
+ 1
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
25th Jun 2024, 8:19 AM
Ausgrindtube
Ausgrindtube - avatar