Table: actor_award
Columns: year
group
award
film_show
result

Question: What is the total number of Years that has the Group, Method Fest Independent Film Festival?
SQL: SELECT COUNT("year") FROM actor_award WHERE "group" = 'method fest independent film festival'

Question: What is the average Year that has the Group, Logie Award, the Award, Most Outstanding Actor, and the Result, nominated?
SQL: SELECT AVG("year") FROM actor_award WHERE "group" = 'logie award' AND "award" = 'most outstanding actor' AND "result" = 'nominated'

Question: Before 2012, which Group has the Result, nominated, the Film/Show, East West 101, and the Award, Best Lead Actor in A Television Drama?
SQL: SELECT "group" FROM actor_award WHERE "result" = 'nominated' AND "year" < 2012 AND "film_show" = 'east west 101' AND "award" = 'best lead actor in a television drama'

Question: After 2008, which Group has the Result, nominated, and the Award, Best Lead Actor in a Television Drama?
SQL: SELECT "group" FROM actor_award WHERE "result" = 'nominated' AND "year" > 2008 AND "award" = 'best lead actor in a television drama'

Question: What is the Award, when the Film/Show is East West 101, and when the year is before 2009, and when the Group is Logie Award?
SQL: SELECT "award" FROM actor_award WHERE "film_show" = 'east west 101' AND "year" < 2009 AND "group" = 'logie award'

Question: What is the Film/Show, when the Year is 2010?
SQL: SELECT "film_show" FROM actor_award WHERE "year" = 2010