Table: sports_award
Columns: sporting_profession
first_place_s
second_place_s
third_place_s
total_placing_s

Question: What is the total number of 3rd place entries that have exactly 8 total placings?
SQL: SELECT COUNT("third_place_s") FROM sports_award WHERE "total_placing_s" = 8

Question: How many second place showings does snooker have?
SQL: SELECT "second_place_s" FROM sports_award WHERE "sporting_profession" = 'Snooker'