Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_74 ( scrapped_sold VARCHAR, builder VARCHAR, name_as_rebuilt VARCHAR )

### Question ###
Which Scrapped/Sold has a Builder of derby, and a Name as rebuilt of ben madigan?

### Accurate SQL ###

SELECT scrapped_sold FROM table_name_74 WHERE builder = "derby" AND name_as_rebuilt = "ben madigan"