which type of transmission is found in a 6 speed automatic?
(AND automotive.transmission_type (JOIN automotive.transmission_type.transmissions m.03qpvxm))