Table: athletics_results
Columns: year
meeting
venue
result
event
extra

Question: What venue had less than 7.4 extra and the result of 4th?
SQL: SELECT "venue" FROM athletics_results WHERE "extra" < 7.4 AND "result" = '4th'

Question: What is the highest extra total before 2003 at the Meeting of all africa games?
SQL: SELECT MAX("extra") FROM athletics_results WHERE "meeting" = 'all africa games' AND "year" < 2003

Question: What year has an extra of 8, and a result of 3rd?
SQL: SELECT "year" FROM athletics_results WHERE "extra" = 8 AND "result" = '3rd'

Question: What year has a venue of algiers, algeria, extra smaller than 8.03, and a Meeting of all africa games?
SQL: SELECT "year" FROM athletics_results WHERE "venue" = 'algiers, algeria' AND "extra" < 8.03 AND "meeting" = 'all africa games'