Хай олл,
есть такой набор записей:

Name event Name student Result 1500 m Finals Zori Seymour 73814 1500 m Finals An Mei Daniels 71015 1500 m Finals Siena Jabon 80512 1500 m Finals Catherine Camara 80100 1500 m Finals Taylor Crichlow 81510 1500 m Finals Jessica Bruton 70425 1500 m Finals Tayla Horan 74623 1500 m Finals Ahziah Hunt 63025 200 m Finals Ahziah Hunt 3410 200 m Finals Jessie Daba 3512 200 m Finals Lexiana Tucci 3608 400 m Finals Zemira Webb 13212 400 m Finals Siena Jabon 12516 400 m Finals Elsie Hastings 12015 400 m Finals Zori Seymour 12823

мне надо получить:

Name event 1st 2nd 3rd 1500 m Finals Ahziah Hunt Jessica Bruton An Mei Daniels

и т.д.
Подскажите, как сделать красиво одним запросом?

http://www.sql.ru/forum/1204090/nuzhna-pomoshh-s-zaprosom