Table: super_gt_2008_2
Columns: team
make
drivers
tyre
rounds

Question: What is the make of the vehicle for driver Hisashi Wada?
SQL: SELECT "make" FROM super_gt_2008_2 WHERE "drivers" = 'hisashi wada'

Question: In what rounds was the featured team of Avanzza Rosso?
SQL: SELECT "rounds" FROM super_gt_2008_2 WHERE "team" = 'avanzza rosso'

Question: In what rounds was the featured driver Tomonobu Fujii with a Tyre of Y?
SQL: SELECT "rounds" FROM super_gt_2008_2 WHERE "tyre" = 'y' AND "drivers" = 'tomonobu fujii'

Question: Who is the driver with a tyre of k for Avanzza Rosso?
SQL: SELECT "drivers" FROM super_gt_2008_2 WHERE "tyre" = 'k' AND "team" = 'avanzza rosso'

Question: What is the tyre for Yoshihisa Namekata?
SQL: SELECT "tyre" FROM super_gt_2008_2 WHERE "drivers" = 'yoshihisa namekata'