select c.approvedby_AD_admin,c.clubid,c.coach_id,c.user_id,c.FullName,c.FirstName,c.LastName,c.Title,s.sport_name,c.first_coaching_season,c.last_coach_season,s.sport_id,c.Program_Gender,c.first_coaching_season,c.last_coach_season from coach c join college_school cs on cs.School_alt_name=c.School_Name join sport_gender s on s.sport_id=c.sport_id and s.gender=c.Program_Gender where c.last_coach_season='Present Coach' and cs.college_school_id='1411' and c.sport_id='7' and c.Program_Gender='W' order by CASE WHEN c.Title = 'Head Coach' THEN 1 WHEN c.Title = 'Co-Head Coach' THEN 2 WHEN c.Title = 'Interim Head Coach' THEN 3 WHEN c.Title = 'Associate Head Coach' THEN 4 WHEN c.Title = 'Assistant Head Coach' THEN 5 WHEN c.Title = 'Assistant Coach' THEN 6 WHEN c.Title = 'Volunteer Assistant Coach' THEN 7 WHEN c.Title = 'Graduate Assistant Coach' THEN 8 WHEN c.Title = 'Student Assistant Coach' THEN 9 WHEN c.Title = 'Intern Assistant Coach' THEN 10 WHEN c.Title = 'Head JV Coach' THEN 11 WHEN c.Title = 'Associate Head JV Coach' THEN 12 WHEN c.Title = 'Assistant JV Coach' THEN 13 WHEN c.Title = 'Volunteer Assistant JV Coach' THEN 14 WHEN c.Title = 'Program Email' THEN 15 ELSE 16 END, c.Title ASC

Coaches	Title