what type of transmission has the highest number of forward gears?
(ARGMAX automotive.transmission_type (JOIN (R automotive.transmission.classification) automotive.transmission.number_of_gears))