SELECT
  "car"."vin" AS "VIN",
  "model"."name" AS "Model",
  "manufacturer"."name" AS "Manufacturer"
FROM "car", "model", "manufacturer"
WHERE
  "car"."model" = "model"."id"
  AND "model"."manufacturer" = "manufacturer"."id";
