What is the name of the school with the highest number of first-time, full-time, degree-seeking female students in the cohort being tracked, minus any exclusions who were seeking another type of degree or certificate at a 4-year institution?
name of the school refers to chronname; highest number of first-time, full-time, degree-seeking female students in the cohort being tracked, minus any exclusions refers to MAX(grad_cohort WHERE gender = 'F'); seeking another type of degree or certificate at a 4-year institution refers to cohort = '4y other';
SELECT T1.chronname FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.gender = 'F' AND T2.cohort = '4y other' ORDER BY T2.grad_cohort DESC LIMIT 1
database name:db_id college_completion
institution_details table institution_details Cols: Unit ID number dtype integer, chronname dtype text, city dtype text, state dtype text, level dtype text, control dtype text, basic dtype text, Historically Black College and Universities dtype text, flagship dtype text, long_x dtype real, lat_y dtype real, site dtype text, student count dtype integer, awards per value dtype real, awards per state value dtype real, awards per national value dtype real, expected award value dtype integer, expected award state value dtype integer, expected award national value dtype integer, exp_award_percentile dtype integer, Full-time percentage dtype real, Full-time percentage dtype integer, fte_percentile dtype integer, median SAT value dtype text, median SAT percentile dtype text, aid value dtype integer, aid percentile dtype integer, endow value dtype text, endow percentile dtype text, graduation 100 value dtype real, graduation 100 percentile dtype integer, graduation 150 value dtype real, graduation 150 percentile dtype integer, pell value dtype real, pell percentile dtype integer, retain value dtype real, retain percentile dtype integer, full time faculty value dtype real, full time faculty percentile dtype integer, voluntary system of accountability year dtype text, voluntary system of accountability after 4 year first time dtype text, voluntary system of accountability graduation elsewhere after 4 year first time dtype text, voluntary system of accountability enrollment after 4 year first time dtype text, voluntary system of accountability enrollment elsewhere after 4 year first time dtype text, voluntary system of accountability graduation elsewhere after 6 year first time dtype text, voluntary system of accountability graduation elsewhere after 6 year first time dtype text, voluntary system of accountability enrollment after 6 year first time dtype text, voluntary system of accountability enrollment elsewhere after 6 year first time dtype text, voluntary system of accountability transfer after 6 year first time dtype text, voluntary system of accountability graduation elsewhere after 4 year dtype text, voluntary system of accountability enrollment after 4 years transfer dtype text, voluntary system of accountability enrollment elsewhere after 4 years transfer dtype text, voluntary system of accountability enrollment elsewhere after 6 years transfer dtype text, voluntary system of accountability graduation elsewhere after 6 years transfer dtype text, voluntary system of accountability enrollment after 6 years transfer dtype text, voluntary system of accountability enrollment elsewhere after 6 years transfer dtype text, similar dtype text, state_sector_ct dtype integer, carnegie_ct dtype integer, counted_pct dtype text, nicknames dtype text, cohort_size dtype integer, 
institution_grads table institution_grads Cols: unit id dtype integer, year dtype integer, gender dtype text, race dtype text, cohort dtype text, graduation cohort dtype text, graduation 100 dtype text, graduation 150 dtype text, grad_100_rate dtype text, grad_150_rate dtype text, 
state_sector_grads table state_sector_grads Cols: state id dtype integer, state name dtype text, state_abbr dtype text, control dtype text, level dtype text, year dtype integer, gender dtype text, race dtype text, cohort dtype text, graduation cohort dtype text, graduation 100 dtype text, graduation 150 dtype text, grad_100_rate dtype text, grad_150_rate dtype text, graduation cohort count dtype integer, 
state_sector_details table state_sector_details Cols: state id dtype integer, state name dtype text, state_post dtype text, level dtype text, control dtype text, schools_count dtype integer, counted percentage dtype text, awards per state value dtype text, awards per national value dtype real, expected award state value dtype text, expected award national value dtype integer, state appropriation value dtype text, state_appr_rank dtype text, grad_rate_rank dtype text, awards_per_rank dtype text, 
