Table: scottish_castles
Columns: name
type
date
condition
ownership

Question: What is the Name of the Historic House of the 18th Century?
SQL: SELECT "name" FROM scottish_castles WHERE "type" = 'historic house' AND "date" = '18th century'

Question: What is the Type of castle from the 14th Century which Condition is preserved?
SQL: SELECT "type" FROM scottish_castles WHERE "date" = '14th century' AND "condition" = 'preserved'

Question: What is the Name of the private Castle of the 16th century which is occupied?
SQL: SELECT "name" FROM scottish_castles WHERE "ownership" = 'private' AND "condition" = 'occupied' AND "date" = '16th century'

Question: What is the Date of the castle with a Historic Scotland Ownership?
SQL: SELECT "date" FROM scottish_castles WHERE "ownership" = 'historic scotland'

Question: What is the Date of the Fortified House?
SQL: SELECT "date" FROM scottish_castles WHERE "type" = 'fortified house'

Question: What is the Date of the Courtyard Castle?
SQL: SELECT "date" FROM scottish_castles WHERE "type" = 'courtyard castle'