what is the type of transmission that is used in the 6 speed manual?
(AND automotive.transmission_type (JOIN automotive.transmission_type.transmissions m.03l_kzc))