Table: episodes_how_its_made
Columns: series_ep
episode
segment_a
segment_b
segment_c
segment_d

Question: Name the number of episods for segment c being s oyster
SQL: SELECT COUNT("episode") FROM episodes_how_its_made WHERE "segment_c" = 's Oyster'

Question: Name the least episode for fibre cement siding
SQL: SELECT MIN("episode") FROM episodes_how_its_made WHERE "segment_d" = 'Fibre Cement Siding'

Question: Name the segment b for 226 episode
SQL: SELECT "segment_b" FROM episodes_how_its_made WHERE "episode" = 226

Question: Name the number of sement d for solar water heaters 
SQL: SELECT COUNT("segment_d") FROM episodes_how_its_made WHERE "segment_b" = 'Solar Water Heaters'

Question: Name the segment d for s cufflink
SQL: SELECT "segment_d" FROM episodes_how_its_made WHERE "segment_a" = 's Cufflink'