Table: shock_wave
Columns: name
style
opened
manufacturer
themed_area

Question: Which average Opened has a Manufacturer of vekoma?
SQL: SELECT AVG("opened") FROM shock_wave WHERE "manufacturer" = 'vekoma'

Question: Which Opened is the highest one that has a Themed Area of aerial park, and a Manufacturer of zamperla?
SQL: SELECT MAX("opened") FROM shock_wave WHERE "themed_area" = 'aerial park' AND "manufacturer" = 'zamperla'

Question: Which Themed Area has a Name of troublesome trucks runaway coaster?
SQL: SELECT "themed_area" FROM shock_wave WHERE "name" = 'troublesome trucks runaway coaster'

Question: Which Manufacturer has a Style of steel sit down, and an Opened larger than 2008?
SQL: SELECT "manufacturer" FROM shock_wave WHERE "style" = 'steel sit down' AND "opened" > 2008