Table: primeira_liga_club_stats
Columns: club
season_s_last_head_coach
city
stadium
2004_2005_season

Question: What is the club from Vila Do Conde?
SQL: SELECT "club" FROM primeira_liga_club_stats WHERE "city" = 'vila do conde'

Question: What is the stadium for the team that was 6th in the liga in the 2004-2005 season?
SQL: SELECT "stadium" FROM primeira_liga_club_stats WHERE "2004_2005_season" = '6th in the liga'

Question: What is the stadium for the city of Braga?
SQL: SELECT "stadium" FROM primeira_liga_club_stats WHERE "city" = 'braga'