Table: atlanta_rollergirls_results
Columns: season
apocalypstix
denim_demons
sake_tuyas
toxic_shocks

Question: How many seasons did Apocalypstix place 2nd?
SQL: SELECT COUNT("season") FROM atlanta_rollergirls_results WHERE "apocalypstix" = '2nd'

Question: What season did the Sake Tuyas come in 1st place?
SQL: SELECT "season" FROM atlanta_rollergirls_results WHERE "sake_tuyas" = '1st'

Question: What is the most recent season where the Denim Demons placed 3rd?
SQL: SELECT MAX("season") FROM atlanta_rollergirls_results WHERE "denim_demons" = '3rd'

Question: What place did the Sake Tuyas come in when the Denim Demons were 4th?
SQL: SELECT "sake_tuyas" FROM atlanta_rollergirls_results WHERE "denim_demons" = '4th'

Question: List all the places that the Apocalypstix occupied when the Denim Demons were 2nd.
SQL: SELECT "apocalypstix" FROM atlanta_rollergirls_results WHERE "denim_demons" = '2nd'