Table: mark_joyce_snooker_stats
Columns: 2002_03
2004_05
2006_07
2007_08
2008_09
2009_10
2010_11
2011_12
2012_13

Question: Name the 2008/09 with 2004/05 of ranking tournaments
SQL: SELECT "2008_09" FROM mark_joyce_snooker_stats WHERE "2004_05" = 'ranking tournaments'

Question: Name the 2010/11 with 2004/05 of not held and 2011/12 of non-ranking
SQL: SELECT "2010_11" FROM mark_joyce_snooker_stats WHERE "2004_05" = 'not held' AND "2011_12" = 'non-ranking'

Question: Name the 2006/07 with 2011/12 of lq and 2010/11 of lq with 2002/03 of lq
SQL: SELECT "2006_07" FROM mark_joyce_snooker_stats WHERE "2011_12" = 'lq' AND "2010_11" = 'lq' AND "2002_03" = 'lq'

Question: Name the 2011/12 with 2008/09 of not held with 2010/11 of not held
SQL: SELECT "2011_12" FROM mark_joyce_snooker_stats WHERE "2008_09" = 'not held' AND "2010_11" = 'not held'

Question: Name the 2009/10 with 2011/12 of lq and 2008/09 of not held
SQL: SELECT "2009_10" FROM mark_joyce_snooker_stats WHERE "2011_12" = 'lq' AND "2008_09" = 'not held'

Question: Name the 2009/10 with 2011/12 of a
SQL: SELECT "2009_10" FROM mark_joyce_snooker_stats WHERE "2011_12" = 'a'