Table: ship_class_history
Columns: number
builder
built
rebuilt
name_as_rebuilt
scrapped_sold

Question: Which Scrapped/Sold has a Name as rebuilt of trostan?
SQL: SELECT "scrapped_sold" FROM ship_class_history WHERE "name_as_rebuilt" = 'trostan'

Question: Which Rebuilt has a Name as rebuilt of binevanagh?
SQL: SELECT "rebuilt" FROM ship_class_history WHERE "name_as_rebuilt" = 'binevanagh'

Question: Which Rebuilt has a Builder of derby, and a Name as rebuilt of ben madigan?
SQL: SELECT "rebuilt" FROM ship_class_history WHERE "builder" = 'derby' AND "name_as_rebuilt" = 'ben madigan'

Question: Which Scrapped/Sold has a Builder of derby, and a Name as rebuilt of ben madigan?
SQL: SELECT "scrapped_sold" FROM ship_class_history WHERE "builder" = 'derby' AND "name_as_rebuilt" = 'ben madigan'