Table: kristofer_awards
Columns: year
award_giving_body
category
nominated_for
result

Question: What's the category for the tween academy: class of 2012 nomination?
SQL: SELECT "category" FROM kristofer_awards WHERE "nominated_for" = 'tween academy: class of 2012'

Question: How many years was famas awards the award giving body?
SQL: SELECT COUNT("year") FROM kristofer_awards WHERE "award_giving_body" = 'famas awards'

Question: What's the result for the category of best actor in a supporting role?
SQL: SELECT "result" FROM kristofer_awards WHERE "category" = 'best actor in a supporting role'