Making a league

Hello,

I have a table of data with the following columns:

Participant

Result (win or lose)

The table has other data in, but I want to make a league to sort by the amounts of wins.

For example:

Participant Won Played

A 5 10
B 4 7

C 3 3

I want this to show up on web page.

I was hoping to do this through the source code on the web page, but I am struggling to do it.

Is there a better way to do this, or a place where I can see an example of the code.

Many Thanks,

Oliver

Try

SELECT Participant, Won, Played FROM tablename ORDER By Won DESCENDING