Problem in listing of teams who have played in the round 'Eighth-final' and year 2014

Backend Development
1

in the output i am missing some teams name, there are 16 teams in expected output but i am getting only 11.
here’s my code

echo -e "\nList of teams who played in the 2014 'Eighth-Final' round:"
echo "$($PSQL "SELECT DISTINCT(name) FROM teams INNER JOIN games ON (teams.team_id = games.winner_id OR teams.team_id = games.opponent_id) WHERE round = 'Eighth-Final' AND year = 2014")"
2

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.