Split Full Name Into First and Last

Each full name consists of exactly two words separated by a space. Return the first_name and last_name as separate columns, ordered by id.

Table schema

Users(id INT PRIMARY KEY, full_name VARCHAR(100))

Sample data

id | full_name
1 | Amit Shah
2 | Riya Patil