• Please provide sample rows and sample output. I would think at a minimum you would need to include the gender and distance columns so you can specify what the other values represent. This should be a trivial query if I am understanding your requirements (which will become crystal clear with sample/output).

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service