What is the highest 3rd-Place, when Club is "Home United FC", and when 4th-Place is less than 1?
CREATE TABLE "top_performing_clubs_in_the_prime_league" (
  "club" text,
  "champions" real,
  "runners_up" real,
  "3rd_place" real,
  "4th_place" real
);
SELECT MAX("3rd_place") FROM "top_performing_clubs_in_the_prime_league" WHERE "club"='home united fc' AND "4th_place"<1;