user: ### NOW ANSWER:
Question: How many locomotives have a name of City of Birmingham
Columns: ['No.', 'Name', 'Livery', 'Locomotive type', 'Wheel Arrangement', 'Builder', 'Year built', 'Status']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, 'Northern Rock II', 'Highland Railway green', 'Steam', '2-6-2', 'Ravenglass & Eskdale Railway', 1989.0, 'In traffic']
SQL:

assistant: SELECT COUNT("No.") FROM "Table" WHERE "Name" = 'City of Birmingham';