Table: ship_history
Columns: number
builder
built
rebuilt
name_as_rebuilt
scrapped_sold

Question: What was the built data for Knocklayd rebuild?
SQL: SELECT "built" FROM ship_history WHERE "name_as_rebuilt" = 'Knocklayd'

Question: How many times does the  rebuilt data contain cannot handle non-empty timestamp argument! 1929 and scrapped data contain cannot handle non-empty timestamp argument! 1954?
SQL: SELECT COUNT("number") FROM ship_history WHERE "rebuilt" = 'Cannot handle non-empty timestamp argument! 1929' AND "scrapped_sold" = 'Cannot handle non-empty timestamp argument! 1954'

Question: What is the built data on the scrapped information that is cannot handle non-empty timestamp argument! 1947?
SQL: SELECT "built" FROM ship_history WHERE "scrapped_sold" = 'Cannot handle non-empty timestamp argument! 1947'

Question: How many times was the rebuilt data cannot handle non-empty timestamp argument! 1934?
SQL: SELECT COUNT("number") FROM ship_history WHERE "rebuilt" = 'Cannot handle non-empty timestamp argument! 1934'

Question: What is the built data for number 34?
SQL: SELECT "built" FROM ship_history WHERE "number" = 34

Question: What is the highest number listed?
SQL: SELECT MAX("number") FROM ship_history