user: Question: Who is the head coach of the team who's venue is Lokomotiv?
Columns: ['Team', 'Location', 'Head Coach', 'Team Captain', 'Venue', 'Capacity', 'Position in 2008']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Amkar', 'Perm', 'Rashid Rakhimov', 'Martin Kushev', 'Zvezda', 19500.0, '4th']
SQL:

assistant: SELECT "Head Coach" FROM "Table" WHERE "Venue" = 'Lokomotiv';