Table: gallion_vessel
Columns: vessel
built
max_speed
length
breadth
flag
propulsion

Question: What is the length when the propulsion is controllable pitch propeller?
SQL: SELECT "length" FROM gallion_vessel WHERE "propulsion" = 'Controllable pitch propeller'

Question: What is the max speed when the vessel is gallion?
SQL: SELECT "max_speed" FROM gallion_vessel WHERE "vessel" = 'Gallion'

Question: How many breadth entries are there when the vessel is marianarray?
SQL: SELECT COUNT("breadth") FROM gallion_vessel WHERE "vessel" = 'Marianarray'

Question: What is the propulsion when the vessel is marianarray?
SQL: SELECT "propulsion" FROM gallion_vessel WHERE "vessel" = 'Marianarray'

Question: How many breadth entries are there when propulsion is jet?
SQL: SELECT COUNT("breadth") FROM gallion_vessel WHERE "propulsion" = 'Jet'