Can't you just do something like this:

SELECT IceRink,Country_IceRink, Name, Gender, Country_Persons, Time, Distance

FROM TbExample

WHERE (Distance = '500' and Gender = 'Man' )

OR (Distance = '1000' and Gender = 'Man' )

OR (Distance = '500' and Gender = 'Female' )

... other permutations

NOTEs:

a) I hope distance really isn't a string

b) you may wish to have an order by of some flavor