user: ### NOW ANSWER:
Question: Who is the head coach for the club from Aveiro?
Columns: ['Club', 'Head Coach', 'City', 'Stadium', '2003–2004 season']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Académica de Coimbra', 'João Carlos Pereira', 'Coimbra', 'Estádio Cidade de Coimbra', '13th in the Liga']
SQL:

assistant: SELECT "Head Coach" FROM "Table" WHERE "City" = 'Aveiro';