Split Full Name into First and Last

Easy
string-functions LinkedIn Workday ADP

Given an employees table with a single full_name column (formatted as 'First Last'), write a query that splits it into separate first_name and last_name columns.

Tables

Hints (2 available)

SQL Editor

Output

Click "Run" to see results...