### Database Schema:
CREATE TABLE status (
	station_id	INTEGER	NULL,
	bikes_available	INTEGER	NULL,
	docks_available	INTEGER	NULL,
	time	TEXT	NULL
);

CREATE TABLE station (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	name	TEXT	NULL,
	lat	REAL	NULL,
	long	REAL	NULL,
	dock_count	INTEGER	NULL,
	city	TEXT	NULL,
	installation_date	TEXT	NULL
);

CREATE TABLE weather (
	date	TEXT	NULL,
	max_temperature_f	INTEGER	NULL,
	mean_temperature_f	INTEGER	NULL,
	min_temperature_f	INTEGER	NULL,
	max_dew_point_f	INTEGER	NULL,
	mean_dew_point_f	INTEGER	NULL,
	min_dew_point_f	INTEGER	NULL,
	max_humidity	INTEGER	NULL,
	mean_humidity	INTEGER	NULL,
	min_humidity	INTEGER	NULL,
	max_sea_level_pressure_inches	REAL	NULL,
	mean_sea_level_pressure_inches	REAL	NULL,
	min_sea_level_pressure_inches	REAL	NULL,
	max_visibility_miles	INTEGER	NULL,
	mean_visibility_miles	INTEGER	NULL,
	min_visibility_miles	INTEGER	NULL,
	max_wind_Speed_mph	INTEGER	NULL,
	mean_wind_speed_mph	INTEGER	NULL,
	max_gust_speed_mph	INTEGER	NULL,
	precipitation_inches	TEXT	NULL,
	cloud_cover	INTEGER	NULL,
	events	TEXT	NULL,
	wind_dir_degrees	INTEGER	NULL,
	zip_code	TEXT	NULL
);

CREATE TABLE trip (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	duration	INTEGER	NULL,
	start_date	TEXT	NULL,
	start_station_name	TEXT	NULL,
	start_station_id	INTEGER	NULL,
	end_date	TEXT	NULL,
	end_station_name	TEXT	NULL,
	end_station_id	INTEGER	NULL,
	bike_id	INTEGER	NULL,
	subscription_type	TEXT	NULL,
	zip_code	INTEGER	NULL
);

### User's Query:
For the rides that started at Market at 10th station and ended at South Van Ness at Market station in August of 2013, which day had the coldest temperature?

### Extra Knowledge:
started at refers to start_station_name; start_station_name = 'Market at 10th'; ended at refers to end_station_name; end_station_name = 'South Van Ness at Market'; in August of 2013 refers to start_date BETWEEN '8/1/2013 0:00' AND '8/31/2013 12:59'; day that had the coldest temperature refers to MIN(min_temperature_f);
SELECT T1.start_date FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T2.date LIKE '8/%/2013' AND T1.start_station_name = 'Market at 10th' AND T1.end_station_name = 'South Van Ness at Market' AND T2.min_temperature_f = ( SELECT MIN(T2.min_temperature_f) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T2.date LIKE '8/%/2013' AND T1.start_station_name = 'Market at 10th' AND T1.end_station_name = 'South Van Ness at Market' )