Which Floors have a Pinnacle height ft (m) of 995 (303), and an Std Rank larger than 6?
CREATE TABLE "tallest_buildings_by_pinnacle_height" (
  "pinn_rank" real,
  "std_rank" real,
  "name" text,
  "pinnacle_height_ft_m" text,
  "standard_height_ft_m" text,
  "floors" real,
  "year" real
);
SELECT MAX("floors") FROM "tallest_buildings_by_pinnacle_height" WHERE "pinnacle_height_ft_m"='995 (303)' AND "std_rank">6;