By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| fullname | firstname | lastname |
|---|---|---|
| john | john | john |
| john doe | john | doe |
| john nick doe | john nick | doe |
| john smith nick doe | john smith nick | doe |
SELECT 4
| fullname | firstname | lastname |
|---|---|---|
| john | john | john |
| john doe | john | doe |
| john nick doe | john nick | doe |
| john smith nick doe | john smith nick | doe |
SELECT 4