which class of ships have the means of propulsion of a diesel engines?
(AND boats.ship_class (JOIN (R boats.ship.ship_class) (JOIN boats.ship.means_of_propulsion m.02crk)))