Restructure people: add first_name and last_name (VARCHAR), fill them from full_name (split at the space), then drop full_name.
people
first_name
last_name
full_name
Run your code to see the output here.