SELECT
  "car"."vin" AS "VIN",
  "model"."name" AS "Model",
  "person"."name" AS "Owner"
FROM "car", "person", "model", "ownership"
WHERE
  "ownership"."car" = "car"."id"
  AND "ownership"."owner" = "person"."id"
  AND "car"."model" = "model"."id";
