### 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:
List the name of stations that were installed from 8/5/2013 to 12/31/2013. Indicate their installation date and city name.

### Extra Knowledge:
from 8/5/2013 to 12/31/2013 refers to installation_date between '8/5/2013' and '12/31/2013';
SELECT name, installation_date, city FROM station WHERE (SUBSTR(CAST(installation_date AS TEXT), 1, INSTR(installation_date, '/') - 1) = '5' AND SUBSTR(CAST(installation_date AS TEXT), INSTR(installation_date, '/') + 1, -6) >= '8' AND SUBSTR(CAST(installation_date AS TEXT), -4) = '2013') OR (SUBSTR(CAST(installation_date AS TEXT), 1, INSTR(installation_date, '/') - 1) IN ( '6', '7', '8', '9', '10', '11', '12' ) AND SUBSTR(CAST(installation_date AS TEXT), -4) = '2013')