Table: bose_sounddock_specs
Columns: version
dock_connection
aux_in
battery
iphone_certified
video_out
dual_voltage

Question: How many times did the sounddock series II aux in?
SQL: SELECT COUNT("aux_in") FROM bose_sounddock_specs WHERE "version" = 'SoundDock series II'

Question: Was the sounddock series I v2 iphone certified?
SQL: SELECT "iphone_certified" FROM bose_sounddock_specs WHERE "version" = 'SoundDock series I v2'

Question: How many connections aux in using FIrewire?
SQL: SELECT COUNT("aux_in") FROM bose_sounddock_specs WHERE "dock_connection" = 'FireWire'

Question: how many video out connections does the sounddock portable have?
SQL: SELECT COUNT("video_out") FROM bose_sounddock_specs WHERE "version" = 'SoundDock Portable'

Question: Does the sounddock series I v2 have dual voltage?
SQL: SELECT "dual_voltage" FROM bose_sounddock_specs WHERE "version" = 'SoundDock series I v2'

Question: What type of dock connection does the sounddock series III have? 
SQL: SELECT "dock_connection" FROM bose_sounddock_specs WHERE "version" = 'SoundDock series III'