What is the TOTAL Time in Office with a rank smaller than 18, and premier is Joh Bjelke-Petersen?
CREATE TABLE "rank_by_time_in_office" (
  "rank" real,
  "premier" text,
  "assumed_office" text,
  "left_office" text,
  "total_time_in_office" text
);
SELECT "total_time_in_office" FROM "rank_by_time_in_office" WHERE "rank"<18 AND "premier"='joh bjelke-petersen';