Microsoft's internal directory needs two new fields for every employee: a short display name like Olivia S. and a handle like olivia.smith.
For every employee, build display_name (first name, a space, the first letter of the last name and a full stop) and handle (first and last name in lower case, joined by a dot).
Expected output
Example of the shape (made-up values):
| emp_id | display_name | handle |
|---|---|---|
| 4 | Liam N. | liam.nguyen |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.