I have a table which displays football results, here are the columns;
Now I want to create a query which outputs not only the results but do the following:
If HomeScore is GREATER than AwayScore, then HomeTeam wins. And if AwayScore is GREATER than HomeScore, then AwayTeam wins. I also want to display which team wins and loses. However, if BOTH the HomeScore and AwayScore matches (both teams have 1 goal each), then display the result as a draw for both Home and Away teams.