Table: light_novel_awards
Columns: year
character
title
author
artist
imprint

Question: what is the average year when the title is baka to test to shōkanjū?
SQL: SELECT AVG("year") FROM light_novel_awards WHERE "title" = 'baka to test to shōkanjū'

Question: what is the title when the imprint is dengeki bunko and the artist is kiyotaka haimura?
SQL: SELECT "title" FROM light_novel_awards WHERE "imprint" = 'dengeki bunko' AND "artist" = 'kiyotaka haimura'

Question: what is the imprint when the title is owari no chronicle (ahead series)?
SQL: SELECT "imprint" FROM light_novel_awards WHERE "title" = 'owari no chronicle (ahead series)'

Question: what is the earliest year when the author is reki kawahara?
SQL: SELECT MIN("year") FROM light_novel_awards WHERE "author" = 'reki kawahara'

Question: who is the character when the artist is take and the year is before 2006?
SQL: SELECT "character" FROM light_novel_awards WHERE "artist" = 'take' AND "year" < 2006