### 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:
How many trips which subscription types were Subscriber and ended in San Jose city?

### Extra Knowledge:
ended in refers to end_station_name;
SELECT COUNT(T1.subscription_type) FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.end_station_name WHERE T1.subscription_type = 'Subscriber' AND T2.city = 'San Jose'