which ship type is of class submarine?
(AND boats.ship_type (JOIN boats.ship_type.ship_class m.074d1))