Table: how_its_made_episodes_4
Columns: series_ep
episode
segment_a
segment_b
segment_c
segment_d

Question: What episode has  a manual motorcycle transmissions section D?
SQL: SELECT SUM("episode") FROM how_its_made_episodes_4 WHERE "segment_d" = 'manual motorcycle transmissions'

Question: What segment A is associated with a Segment C of paint chip cards?
SQL: SELECT "segment_a" FROM how_its_made_episodes_4 WHERE "segment_c" = 'paint chip cards'

Question: What segment A is associated with a Segment D of manual motorcycle transmissions?
SQL: SELECT "segment_a" FROM how_its_made_episodes_4 WHERE "segment_d" = 'manual motorcycle transmissions'