### Database Schema:
CREATE TABLE institution_grads (
	unitid	INTEGER	NULL,
	year	INTEGER	NULL,
	gender	TEXT	NULL,
	race	TEXT	NULL,
	cohort	TEXT	NULL,
	grad_cohort	TEXT	NULL,
	grad_100	TEXT	NULL,
	grad_150	TEXT	NULL,
	grad_100_rate	TEXT	NULL,
	grad_150_rate	TEXT	NULL,
	foreign key (unitid) references institution_details (unitid)
);

CREATE TABLE state_sector_grads (
	stateid	INTEGER	NULL,
	state	TEXT	NULL,
	state_abbr	TEXT	NULL,
	control	TEXT	NULL,
	level	TEXT	NULL,
	year	INTEGER	NULL,
	gender	TEXT	NULL,
	race	TEXT	NULL,
	cohort	TEXT	NULL,
	grad_cohort	TEXT	NULL,
	grad_100	TEXT	NULL,
	grad_150	TEXT	NULL,
	grad_100_rate	TEXT	NULL,
	grad_150_rate	TEXT	NULL,
	grad_cohort_ct	INTEGER	NULL,
	foreign key (state) references institution_details (state),
	foreign key (stateid) references state_sector_details (stateid)
);

CREATE TABLE state_sector_details (
	stateid	INTEGER	NULL	PRIMARY KEY,
	state	TEXT	NULL,
	state_post	TEXT	NULL,
	level	TEXT	NULL	PRIMARY KEY,
	control	TEXT	NULL	PRIMARY KEY,
	schools_count	INTEGER	NULL,
	counted_pct	TEXT	NULL,
	awards_per_state_value	TEXT	NULL,
	awards_per_natl_value	REAL	NULL,
	exp_award_state_value	TEXT	NULL,
	exp_award_natl_value	INTEGER	NULL,
	state_appr_value	TEXT	NULL,
	state_appr_rank	TEXT	NULL,
	grad_rate_rank	TEXT	NULL,
	awards_per_rank	TEXT	NULL,
	foreign key (state) references institution_details (state)
);

CREATE TABLE institution_details (
	unitid	INTEGER	NULL	PRIMARY KEY,
	chronname	TEXT	NULL,
	city	TEXT	NULL,
	state	TEXT	NULL,
	level	TEXT	NULL,
	control	TEXT	NULL,
	basic	TEXT	NULL,
	hbcu	TEXT	NULL,
	flagship	TEXT	NULL,
	long_x	REAL	NULL,
	lat_y	REAL	NULL,
	site	TEXT	NULL,
	student_count	INTEGER	NULL,
	awards_per_value	REAL	NULL,
	awards_per_state_value	REAL	NULL,
	awards_per_natl_value	REAL	NULL,
	exp_award_value	INTEGER	NULL,
	exp_award_state_value	INTEGER	NULL,
	exp_award_natl_value	INTEGER	NULL,
	exp_award_percentile	INTEGER	NULL,
	ft_pct	REAL	NULL,
	fte_value	INTEGER	NULL,
	fte_percentile	INTEGER	NULL,
	med_sat_value	TEXT	NULL,
	med_sat_percentile	TEXT	NULL,
	aid_value	INTEGER	NULL,
	aid_percentile	INTEGER	NULL,
	endow_value	TEXT	NULL,
	endow_percentile	TEXT	NULL,
	grad_100_value	REAL	NULL,
	grad_100_percentile	INTEGER	NULL,
	grad_150_value	REAL	NULL,
	grad_150_percentile	INTEGER	NULL,
	pell_value	REAL	NULL,
	pell_percentile	INTEGER	NULL,
	retain_value	REAL	NULL,
	retain_percentile	INTEGER	NULL,
	ft_fac_value	REAL	NULL,
	ft_fac_percentile	INTEGER	NULL,
	vsa_year	TEXT	NULL,
	vsa_grad_after4_first	TEXT	NULL,
	vsa_grad_elsewhere_after4_first	TEXT	NULL,
	vsa_enroll_after4_first	TEXT	NULL,
	vsa_enroll_elsewhere_after4_first	TEXT	NULL,
	vsa_grad_after6_first	TEXT	NULL,
	vsa_grad_elsewhere_after6_first	TEXT	NULL,
	vsa_enroll_after6_first	TEXT	NULL,
	vsa_enroll_elsewhere_after6_first	TEXT	NULL,
	vsa_grad_after4_transfer	TEXT	NULL,
	vsa_grad_elsewhere_after4_transfer	TEXT	NULL,
	vsa_enroll_after4_transfer	TEXT	NULL,
	vsa_enroll_elsewhere_after4_transfer	TEXT	NULL,
	vsa_grad_after6_transfer	TEXT	NULL,
	vsa_grad_elsewhere_after6_transfer	TEXT	NULL,
	vsa_enroll_after6_transfer	TEXT	NULL,
	vsa_enroll_elsewhere_after6_transfer	TEXT	NULL,
	similar	TEXT	NULL,
	state_sector_ct	INTEGER	NULL,
	carnegie_ct	INTEGER	NULL,
	counted_pct	TEXT	NULL,
	nicknames	TEXT	NULL,
	cohort_size	INTEGER	NULL
);

### User's Query:
How many students for both genders graduated from a 2-year institute in Alabama in 2011?

### Extra Knowledge:
2-year institute refers to cohort = '2y all'; Alabama refers to state = 'Alabama'; in 2011 refers to year = 2011; T2.gender = 'B' means both genders;
SELECT SUM(T2.grad_cohort) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE  T2.cohort = '2y all' AND T2.year = 2011 AND T1.state = 'Alabama'