Table: nsl_champs
Columns: season
cup_finaldate
winningteam
score
losingteam
location
cup_final_attendance

Question: How many losingteams were for the cup finaldate 20 August 1989?
SQL: SELECT COUNT("losingteam") FROM nsl_champs WHERE "cup_finaldate" = '20 August 1989'

Question: How many seasons was the losing team Adelaide City?
SQL: SELECT COUNT("season") FROM nsl_champs WHERE "losingteam" = 'Adelaide City'

Question: Who was the winning team in the 1989 season?
SQL: SELECT "winningteam" FROM nsl_champs WHERE "season" = '1989'