Table: premiers_ql
Columns: rank
premier
assumed_office
left_office
total_time_in_office

Question: What is the TOTAL Time in Office with a rank smaller than 18, and premier is Joh Bjelke-Petersen?
SQL: SELECT "total_time_in_office" FROM premiers_ql WHERE "rank" < 18 AND "premier" = 'joh bjelke-petersen'

Question: What is the assumed Office date when the TOTAL Time in Office is 5years, 316days?
SQL: SELECT "assumed_office" FROM premiers_ql WHERE "total_time_in_office" = '5years, 316days'