filename = 'my_football_stats.csv'
f1 = open(filename, 'w')

headers = 'Number_of_Teams, Fewest_games_won, Highest_goals, Average_drawn_games \n'
f1.write(headers)

cursor.execute(''' SELECT COUNT(Team) AS Number_of_Teams,
                             min(W) AS Fewest_games_won,
                             max(F) AS Highest_goals,
                             avg(D) AS Average_drawn_games
                             FROM football;''')

result = cursor.fetchall()

print(result)

for row in result:
     f1.write(str(row[0]) + ',' + str(row[1]) + ',' + str(row[2]) + ',' + str(row[3]) + '\n')

f1.close()