Table: kym_ng_awards
Columns: year
organisation
award
nominated_work_title
result

Question: what is the organisation when the year is less than 2005 and the award is the best variety show host?
SQL: SELECT "organisation" FROM kym_ng_awards WHERE "year" < 2005 AND "award" = 'best variety show host'

Question: what is the organisation when the nominated work title is n/a in the year 2005?
SQL: SELECT "organisation" FROM kym_ng_awards WHERE "nominated_work_title" = 'n/a' AND "year" = 2005

Question: what is the lowest year with the result is nominated for the work title is love bites?
SQL: SELECT MIN("year") FROM kym_ng_awards WHERE "result" = 'nominated' AND "nominated_work_title" = 'love bites'

Question: what is the year when then organisation is star awards, the result is won and the nominated work title is n/a?
SQL: SELECT "year" FROM kym_ng_awards WHERE "organisation" = 'star awards' AND "result" = 'won' AND "nominated_work_title" = 'n/a'

Question: what is the latest year that has the result of nominated and the nominated work title is n/a?
SQL: SELECT MAX("year") FROM kym_ng_awards WHERE "result" = 'nominated' AND "nominated_work_title" = 'n/a'

Question: what is the nominated work title when the result is won, the organisation is star awards and the award is top 10 most popular female artiste in the year 2007?
SQL: SELECT "nominated_work_title" FROM kym_ng_awards WHERE "result" = 'won' AND "organisation" = 'star awards' AND "award" = 'top 10 most popular female artiste' AND "year" > 2007