What segment A is associated with a Segment D of manual motorcycle transmissions?
CREATE TABLE table_name_76 (segment_a VARCHAR, segment_d VARCHAR)
SELECT segment_a FROM table_name_76 WHERE segment_d = "manual motorcycle transmissions"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (segment_a VARCHAR, segment_d VARCHAR) Question: What segment A is associated with a Segment D of manual motorcycle transmissions? [/INST] SELECT segment_a FROM table_name_76 WHERE segment_d = "manual motorcycle transmissions" </s>