user: ### NOW ANSWER:
Question: How many locomotives have a livery that is Highland Railway green
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("Name") FROM "Table" WHERE "Livery" = 'Highland Railway green';