-- Database schema
| station : id [ INTEGER ] primary_key , name [ TEXT ] , lat [ REAL ] , long [ REAL ] , dock_count [ INTEGER ] , city [ TEXT ] , installation_date [ TEXT ] | status : station_id [ INTEGER ] , bikes_available [ INTEGER ] , docks_available [ INTEGER ] , time [ TEXT ] | trip : id [ INTEGER ] primary_key , duration [ INTEGER ] , start_date [ TEXT ] , start_station_name [ TEXT ] , start_station_id [ INTEGER ] , end_date [ TEXT ] , end_station_name [ TEXT ] , end_station_id [ INTEGER ] , bike_id [ INTEGER ] , subscription_type [ TEXT ] , zip_code [ INTEGER ] | weather : date [ TEXT ] , max_temperature_f [ INTEGER ] , mean_temperature_f [ INTEGER ] , min_temperature_f [ INTEGER ] , max_dew_point_f [ INTEGER ] , mean_dew_point_f [ INTEGER ] , min_dew_point_f [ INTEGER ] , max_humidity [ INTEGER ] , mean_humidity [ INTEGER ] , min_humidity [ INTEGER ] , max_sea_level_pressure_inches [ REAL ] , mean_sea_level_pressure_inches [ REAL ] , min_sea_level_pressure_inches [ REAL ] , max_visibility_miles [ INTEGER ] , mean_visibility_miles [ INTEGER ] , min_visibility_miles [ INTEGER ] , max_wind_Speed_mph [ INTEGER ] , mean_wind_speed_mph [ INTEGER ] , max_gust_speed_mph [ INTEGER ] , precipitation_inches [ TEXT ] , cloud_cover [ INTEGER ] , events [ TEXT ] , wind_dir_degrees [ INTEGER ] , zip_code [ TEXT ] |
-- -- How long did it take for bike id 426 to reach 2nd at South Park from Market at 4th on 8/29/2013? Indicate the duration in minutes.

SELECT CAST(duration AS REAL) / 60  FROM trip WHERE bike_id = 426 AND end_station_name = '2nd at South Park' AND start_station_name = 'Market at 4th' AND start_date LIKE '8/29/2013%' AND end_date LIKE '8/29/2013%';