Question: Imagine that you have a table Users with users first and last names and you are trying to create a column username where the first
Imagine that you have a table Users with users first and last names and you are trying to create a column username where the first letter of the username is the first letter of the first name and the remaining letters in the username are the first 5 letters in the last name.
The original table Users
| First_name | Last_name |
| Wolfgang | Mozart |
| Ludwing | Beethoven |
| Antonio | Vivaldi |
Result
| First_name | Last_name | username |
| Wolfgang | Mozart | wmozar |
| Ludwing | Beethoven | lbeeth |
| Antonio | Vivaldi | avival |
Write the SQL query that returns the result table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
