Table: shuzenji_romney_locomotive
Columns: no
name
livery
locomotive_type
wheel_arrangement
builder
year_built
status

Question: How many locomotives have a name of City of Birmingham
SQL: SELECT COUNT("no") FROM shuzenji_romney_locomotive WHERE "name" = 'City of Birmingham'

Question: How many locomotives have a livery that is highland railway green
SQL: SELECT COUNT("name") FROM shuzenji_romney_locomotive WHERE "livery" = 'Highland Railway green'

Question: Which locomotive type has a status in static display
SQL: SELECT "locomotive_type" FROM shuzenji_romney_locomotive WHERE "status" = 'Static display'