Table: kiprono_1500m
Columns: surface
event
time_h_m_s
date
place

Question: When has a surface of road and an event of half marathon?
SQL: SELECT "date" FROM kiprono_1500m WHERE "surface" = 'road' AND "event" = 'half marathon'

Question: Which Surface has a Place of lappeenranta?
SQL: SELECT "surface" FROM kiprono_1500m WHERE "place" = 'lappeenranta'

Question: What is the Date that has 1:01:42?
SQL: SELECT "date" FROM kiprono_1500m WHERE "time_h_m_s" = '1:01:42'

Question: What is the Time ( h : m : s ) on 13 october 2010
SQL: SELECT "time_h_m_s" FROM kiprono_1500m WHERE "date" = '13 october 2010'

Question: What is the Place with Time  7:44.15?
SQL: SELECT "place" FROM kiprono_1500m WHERE "time_h_m_s" = '7:44.15'