Table: mao_inoue_award
Columns: year
organization
award
work
result

Question: Where Result is nominated and Organization is 54th the television academy drama awards, what is the award?
SQL: SELECT "award" FROM mao_inoue_award WHERE "result" = 'nominated' AND "organization" = '54th the television academy drama awards'

Question: Where Work is veterinarian dolittle, what is the Organization?
SQL: SELECT "organization" FROM mao_inoue_award WHERE "work" = 'veterinarian dolittle'

Question: Where Award is newcomer actress, what is the work?
SQL: SELECT "work" FROM mao_inoue_award WHERE "award" = 'newcomer actress'

Question: Where Award is best actress and Work is first kiss, what is the average Year?
SQL: SELECT AVG("year") FROM mao_inoue_award WHERE "award" = 'best actress' AND "work" = 'first kiss'