INSERT INTO "ownership" ("owner", "car")
  VALUES (
    (SELECT "person"."id" FROM "person"
      WHERE "person"."name" = 'Doe, Janet'),
    (SELECT "car"."id" FROM "car"
      WHERE "car"."vin" = '0123456789abcdefg')
  );

INSERT INTO "ownership" ("owner", "car")
  VALUES (
    (SELECT "person"."id" FROM "person"
      WHERE "person"."name" = 'Doe, John'),
    (SELECT "car"."id" FROM "car"
      WHERE "car"."vin" = '0123456789abcdefg')
  );

INSERT INTO "ownership" ("owner", "car")
  VALUES (
    (SELECT "person"."id" FROM "person"
      WHERE "person"."name" = 'Shute, Gary'),
    (SELECT "car"."id" FROM "car"
      WHERE "car"."vin" = 'abcdefg0123456789')
  );
