Table: targa_tasmania_2008
Columns: driver
navigator
vehicle
class
capacity
total_time
margin

Question: What is the average capacity for the vehicle having a navigator of Macneall?
SQL: SELECT AVG("capacity") FROM targa_tasmania_2008 WHERE "navigator" = 'macneall'

Question: Which vehicle had a class of CM14?
SQL: SELECT "vehicle" FROM targa_tasmania_2008 WHERE "class" = 'cm14'

Question: Who was the driver of the vehicle having class of CM22 and navigator of Macneall?
SQL: SELECT "driver" FROM targa_tasmania_2008 WHERE "class" = 'cm22' AND "navigator" = 'macneall'

Question: What is the total time of the vehicle having a navigator of Vandenberg?
SQL: SELECT "total_time" FROM targa_tasmania_2008 WHERE "navigator" = 'vandenberg'