For what Japanese title is there less than 11 episodes and the Romaji title is Regatta~Kimi to Ita Eien~?
CREATE TABLE "2006_summer_season" (
  "japanese_title" text,
  "romaji_title" text,
  "tv_station" text,
  "episodes" real,
  "average_ratings" text
);
SELECT "japanese_title" FROM "2006_summer_season" WHERE "episodes"<11 AND "romaji_title"='regatta~kimi to ita eien~';