Where is pine valley?
CREATE TABLE "top_100_in_the_united_states" (
  "rank" real,
  "name" text,
  "location" text,
  "state" text,
  "designer_year" text
);
SELECT "location" FROM "top_100_in_the_united_states" WHERE "name"='pine valley';