Table: super_gt_2008
Columns: team
make
drivers
tyre
rounds

Question: What is the tyre of nismo team member satoshi motoyama when he has rounds of all?
SQL: SELECT "tyre" FROM super_gt_2008 WHERE "rounds" = 'all' AND "team" = 'nismo' AND "drivers" = 'satoshi motoyama'

Question: What is the tyre of real racing with leon team member koudai tsukakoshi?
SQL: SELECT "tyre" FROM super_gt_2008 WHERE "team" = 'real racing with leon' AND "drivers" = 'koudai tsukakoshi'

Question: Which drives drove a lexus, made all rounds, had a tyre of B and was on the team of petronas toyota team tom's?
SQL: SELECT "drivers" FROM super_gt_2008 WHERE "rounds" = 'all' AND "make" = 'lexus' AND "tyre" = 'b' AND "team" = 'petronas toyota team tom''s'

Question: When driver yuji tachikawa had a make of lexus, what team did he represent?
SQL: SELECT "team" FROM super_gt_2008 WHERE "make" = 'lexus' AND "drivers" = 'yuji tachikawa'