Table: liga_club_stats
Columns: club
head_coach
city
stadium
2002_2003_season

Question: What city is the Stadium estádio dr. magalhães pessoa in?
SQL: SELECT "city" FROM liga_club_stats WHERE "stadium" = 'estádio dr. magalhães pessoa'

Question: What city is the Stadium estádio cidade de barcelos in?
SQL: SELECT "city" FROM liga_club_stats WHERE "stadium" = 'estádio cidade de barcelos'

Question: Head Coach casemiro mior is at which Club?
SQL: SELECT "club" FROM liga_club_stats WHERE "head_coach" = 'casemiro mior'

Question: What City is the Club braga in?
SQL: SELECT "city" FROM liga_club_stats WHERE "club" = 'braga'

Question: What place is listed in the 2002-2003 season for the City of Aveiro?
SQL: SELECT "2002_2003_season" FROM liga_club_stats WHERE "city" = 'aveiro'