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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!