calculate league table

[eluser]mirag3[/eluser]
Hi, i need to generate a league table for 1 season with these columns: position, points, name, wins, wins_ot, loses, loses_ot, goals scored, goals conceded. Rows are sorted by: 1. points 2. goals scored . In this league cannot be draw, overtime is needed. My tables looks like this:

#Matches
- match_id
- hometeam_id
- awayteam_id
- location
- season_id

#Seasons
- season_id
- name
- key

#Results
- result_id
- match_id
- hometeam_id
- awayteam_id
- hometeam_goals
- awayteam_goals
- overtime


I dont know how will look select and view. Can anybody help me please? Thanks much. I can pay some small amount on paypal/skrill after good advices/help.