Insert a new author (id 6, name 'Nadia Frost', country 'Canada', born 1979) and RETURN the id and name.

Answer

INSERT INTO authors (id, name, country, born) VALUES (6, 'Nadia Frost', 'Canada', 1979) RETURNING id, name;