Table: modern_pentathlon_2008_women
Columns: athlete
shooting_score_pts
fencing_victories_pts
swimming_time_pts
equestrian_time_pts
running_time_pts
total

Question: Which Fencing Victories (pts) has a Shooting Score (pts) of 187 (1180) and a Total smaller than 5640? Question 1
SQL: SELECT "fencing_victories_pts" FROM modern_pentathlon_2008_women WHERE "shooting_score_pts" = '187 (1180)' AND "total" < 5640

Question: Which Equestrian Time (pts) has an Athlete of omnia fakhry ( egy )?
SQL: SELECT "equestrian_time_pts" FROM modern_pentathlon_2008_women WHERE "athlete" = 'omnia fakhry ( egy )'

Question: Which Shooting Score (pts) has a Total larger than 5464 and a Athlete of heather fell ( gbr )?
SQL: SELECT "shooting_score_pts" FROM modern_pentathlon_2008_women WHERE "total" > 5464 AND "athlete" = 'heather fell ( gbr )'

Question: Which Fencing Victories (pts) that has a Equestrian Time (pts) of 67.88 (1144)?
SQL: SELECT "fencing_victories_pts" FROM modern_pentathlon_2008_women WHERE "equestrian_time_pts" = '67.88 (1144)'

Question: Which Fencing Victories (pts) has a Total of 5640?
SQL: SELECT "fencing_victories_pts" FROM modern_pentathlon_2008_women WHERE "total" = 5640