Table: shota_matsuda_appearances
Columns: year
title
original_channel
role
note

Question: what is the year when the title is jotei?
SQL: SELECT SUM("year") FROM shota_matsuda_appearances WHERE "title" = 'jotei'

Question: what is the original channel when the year is before 2006 and the note is supporting?
SQL: SELECT "original_channel" FROM shota_matsuda_appearances WHERE "year" < 2006 AND "note" = 'supporting'

Question: what is the original channel when the note is co-star in year 2012?
SQL: SELECT "original_channel" FROM shota_matsuda_appearances WHERE "note" = 'co-star' AND "year" = 2012

Question: what is the original channel when the year is after 2012?
SQL: SELECT "original_channel" FROM shota_matsuda_appearances WHERE "year" > 2012

Question: what is the year when the note is supporting and the title is rokumeikan?
SQL: SELECT "year" FROM shota_matsuda_appearances WHERE "note" = 'supporting' AND "title" = 'rokumeikan'

Question: what is the title when the year is after 2011 and the original channel is nhk?
SQL: SELECT "title" FROM shota_matsuda_appearances WHERE "year" > 2011 AND "original_channel" = 'nhk'