human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Sporting profession, First place(s), Second place(s), Third place(s), Total placing(s)
###Question: How many second place showings does snooker have?
gpt
SELECT Second place(s) FROM table WHERE Sporting profession = Snooker