SHELL试题（码农的欧洲杯：欢迎各路神仙和高手挑战！）（转发）

下面是欧洲杯的大名单,每个队23个人一共16个队
求:
1.年纪最小的人
2.年纪最大的人
3.哪一天出生的人最多
4.和你生日相同的人,如果有的话找出来
5.给定一个球员名,列出国籍与教练,处在哪个小组
6.哪个俱乐部的人最多
7.队长里打什么位置的最多
8.比你年纪大的有多少人
9.列出365天里所有人都不过生日的日期
10.打各个位置的人一共有多少

11. 画出运动员各年龄段的分布图

 

说明:
1.由于长度限制,只贴了2个小组的队伍,附件里全的

Group A

Poland

Head coach:  Franciszek Smuda (Poland)

  # Pos. Player                   Date of Birth (Age)     Club
  1  GK  Wojciech Szczesny        (1990-04-18)  (aged 22) Arsenal
  2  DF  Sebastian Boenisch       (1987-02-01)  (aged 25) Werder Bremen
  3  DF  Grzegorz Wojtkowiak      (1984-01-26)  (aged 28) Lech Poznan
  4  DF  Damien Perquis           (1984-10-04)  (aged 27) Sochaux
  5  MF  Dariusz Dudka            (1983-12-09)  (aged 28) Auxerre
  6  MF  Adam Matuszczyk          (1989-02-14)  (aged 23) Fortuna Dusseldorf
  7  MF  Eugen Polanski           (1986-03-17)  (aged 26) Mainz 05
  8  MF  Maciej Rybus             (1989-08-19)  (aged 22) Terek Grozny
  9  FW  Robert Lewandowski       (1988-08-21)  (aged 23) Borussia Dortmund
 10  MF  Ludovic Obraniak         (1984-11-10)  (aged 27) Bordeaux
 11  MF  Rafal Murawski           (1981-10-09)  (aged 30) Lech Poznan
 12  GK  Grzegorz Sandomierski    (1989-09-05)  (aged 22) Jagiellonia Biallystok
 13  DF  Marcin Wasilewski        (1980-06-09)  (aged 31) Anderlecht
 14  DF  Jakub Wawrzyniak         (1983-07-07)  (aged 28) Legia Warsaw
 15  DF  Marcin Kamimski          (1992-01-15)  (aged 20) Lech Poznan
 16  MF  Jakub Blaszczykowski (c) (1985-12-14)  (aged 26) Borussia Dortmund
 17  MF  Rafal Wolski             (1992-11-10)  (aged 19) Legia Warsaw
 18  MF  Adrian Mierzejewski      (1986-11-04)  (aged 25) Trabzonspor
 19  FW  Artur Sobiech            (1990-06-12)  (aged 21) Hannover 96
 20  DF  Lukasz Piszczek          (1985-06-03)  (aged 27) Borussia Dortmund
 21  MF  Kamil Grosicki           (1988-06-08)  (aged 24) Sivasspor
 22  GK  Przemyslaw Tytom         (1987-01-04)  (aged 25) PSV Eindhoven
 23  FW  Pawel Brozek             (1983-04-21)  (aged 29) Celtic

Greece

Head coach:  Fernando Santos (Portugal)

  # Pos. Player                    Date of Birth (Age)     Club
  1  GK  Kostas Chalkias           (1974-05-30)  (aged 38) P.A.O.K.
  2  DF  Ioannis Maniatis          (1986-10-12)  (aged 25) Olympiacos
  3  DF  Giorgos Tzavelas          (1987-11-26)  (aged 24) Monaco
  4  DF  Stelios Malezas           (1985-03-11)  (aged 27) P.A.O.K.
  5  DF  Kyriakos Papadopoulos     (1992-02-23)  (aged 20) Schalke 04
  6  MF  Grigoris Makos            (1987-01-18)  (aged 25) AEK Athens
  7  FW  Giorgos Samaras           (1985-02-21)  (aged 27) Celtic
  8  DF  Avraam Papadopoulos       (1984-12-03)  (aged 27) Olympiacos
  9  FW  Nikos Lyberopoulos        (1975-08-04)  (aged 36) AEK Athens
 10  MF  Giorgos Karagounis (c)    (1977-03-06)  (aged 35) Panathinaikos
 11  FW  Kostas Mitroglou          (1988-03-12)  (aged 24) Atromitos
 12  GK  Alexandros Tzorvas        (1982-08-12)  (aged 29) Palermo
 13  GK  Michalis Sifakis          (1984-09-09)  (aged 27) Aris Thessaloniki
 14  FW  Dimitris Salpigidis       (1981-08-18)  (aged 30) P.A.O.K
 15  DF  Vasilis Torosidis         (1985-06-10)  (aged 26) Olympiacos
 16  MF  Giorgos Fotakis           (1981-10-29)  (aged 30) P.A.O.K
 17  FW  Theofanis Gekas           (1980-05-23)  (aged 32) Samsunspor
 18  MF  Sotiris Ninis             (1990-04-03)  (aged 22) Panathinaikos
 19  DF  Sokratis Papastathopoulos (1988-06-09)  (aged 23) Werder Bremen
 20  DF  Jose Holebas              (1984-06-27)  (aged 27) Olympiacos
 21  MF  Kostas Katsouranis        (1979-06-21)  (aged 32) Panathinaikos
 22  MF  Kostas Fortounis          (1992-10-16)  (aged 19) Kaiserslautern
 23  MF  Giannis Fetfatzidis       (1990-12-21)  (aged 21) Olympiacos

Russia

Head coach:  Dick Advocaat (Netherlands)

  # Pos. Player              Date of Birth (Age)     Club
  1  GK  Igor Akinfeev       (1986-04-08)  (aged 26) CSKA Moscow
  2  DF  Aleksandr Anyukov   (1982-09-28)  (aged 29) Zenit Saint Petersburg
  3  DF  Roman Sharonov      (1976-09-08)  (aged 35) Rubin Kazan
  4  DF  Sergei Ignashevich  (1979-07-14)  (aged 32) CSKA Moscow
  5  DF  Yuri Zhirkov        (1983-08-20)  (aged 28) Anzhi Makhachkala
  6  MF  Roman Shirokov      (1981-07-06)  (aged 30) Zenit Saint Petersburg
  7  MF  Igor Denisov        (1984-05-17)  (aged 28) Zenit Saint Petersburg
  8  MF  Konstantin Zyryanov (1977-10-05)  (aged 34) Zenit Saint Petersburg
  9  MF  Marat Izmailov      (1982-09-21)  (aged 29) Sporting CP
 10  FW  Andrei Arshavin (c) (1981-05-29)  (aged 31) Zenit Saint Petersburg
 11  FW  Aleksandr Kerzhakov (1982-11-27)  (aged 29) Zenit Saint Petersburg
 12  DF  Aleksei Berezutski  (1982-06-20)  (aged 29) CSKA Moscow
 13  GK  Anton Shunin        (1987-01-27)  (aged 25) Dynamo Moscow
 14  FW  Roman Pavlyuchenko  (1981-12-15)  (aged 30) Lokomotiv Moscow
 15  MF  Dmitri Kombarov     (1987-01-22)  (aged 25) Spartak Moscow
 16  GK  Vyacheslav Malafeev (1979-03-04)  (aged 33) Zenit Saint Petersburg
 17  MF  Alan Dzagoev        (1990-06-17)  (aged 21) CSKA Moscow
 18  FW  Aleksandr Kokorin   (1991-03-19)  (aged 21) Dynamo Moscow
 19  DF  Vladimir Granat     (1987-05-22)  (aged 25) Dynamo Moscow
 20  FW  Pavel Pogrebnyak    (1983-11-08)  (aged 28) Fulham
 21  DF  Kirill Nababkin     (1986-09-08)  (aged 25) CSKA Moscow
 22  MF  Denis Glushakov     (1987-01-27)  (aged 25) Lokomotiv Moscow
 23  MF  Igor Semshov        (1978-04-06)  (aged 34) Dynamo Moscow

Czech Republic

Head coach:  Michal Bilek (Czech Republic)

  # Pos. Player                 Date of Birth (Age)     Club
  1  GK  Petr Cech              (1982-05-20)  (aged 30) Chelsea
  2  DF  Theodor Gebre Selassie (1986-12-24)  (aged 25) Slovan Liberec
  3  DF  Michal Kadlec          (1984-12-13)  (aged 27) Bayer Leverkusen
  4  DF  Marek Suchy            (1988-03-29)  (aged 24) Spartak Moscow
  5  DF  Roman Hubnik           (1984-06-06)  (aged 28) Hertha BSC
  6  DF  Tomas Sivok            (1983-09-15)  (aged 28) Besiktas
  7  FW  Tomas Necid            (1989-08-13)  (aged 22) CSKA Moscow
  8  DF  David Limbersky        (1983-10-06)  (aged 28) Viktoria Plzen
  9  MF  Jan Rezek              (1982-05-05)  (aged 30) Anorthosis Famagusta
 10  MF  Tomas Rosicky (c)      (1980-10-04)  (aged 31) Arsenal
 11  MF  Milan Petrzela         (1983-06-19)  (aged 28) Viktoria Plzen
 12  DF  Frantisek Rajtoral     (1986-03-12)  (aged 26) Viktoria Plzen
 13  MF  Jaroslav Plasil        (1982-01-05)  (aged 30) Bordeaux
 14  MF  Vaclav Pilar           (1988-10-13)  (aged 23) Viktoria Plzen
 15  FW  Milan Baros            (1981-10-28)  (aged 30) Galatasaray
 16  GK  Jan Lastuvka           (1982-07-07)  (aged 29) Dnipro Dnipropetrovsk
 17  MF  Tomas Hubschman        (1981-09-04)  (aged 30) Shakhtar Donetsk
 18  MF  Daniel Kolar           (1985-10-27)  (aged 26) Viktoria Plzen
 19  MF  Petr Jiracek           (1986-03-02)  (aged 26) VfL Wolfsburg
 20  FW  Tomas Pekhart          (1989-05-26)  (aged 23) Nurnberg
 21  FW  David Lafata           (1981-09-18)  (aged 30) FK Jablonec
 22  MF  Vladimir Darida        (1990-08-08)  (aged 21) FC Viktoria Plzen
 23  GK  Jaroslav Drobny        (1979-10-18)  (aged 32) Hamburger SV

Group B

Netherlands

Head coach:  Bert van Marwijk (Netherlands)

  # Pos. Player               Date of Birth (Age)     Club
  1  GK  Maarten Stekelenburg (1982-09-22)  (aged 29) Roma
  2  DF  Gregory van der Wiel (1988-02-03)  (aged 24) Ajax
  3  DF  John Heitinga        (1983-11-15)  (aged 28) Everton
  4  DF  Joris Mathijsen      (1980-04-05)  (aged 32) Malaga
  5  DF  Wilfred Bouma        (1978-06-15)  (aged 33) PSV
  6  MF  Mark van Bommel (c)  (1977-04-22)  (aged 35) Milan
  7  FW  Dirk Kuyt            (1980-07-22)  (aged 31) Liverpool
  8  MF  Nigel de Jong        (1984-11-30)  (aged 27) Manchester City
  9  FW  Klaas-Jan Huntelaar  (1983-08-12)  (aged 28) Schalke 04
 10  MF  Wesley Sneijder      (1984-06-09)  (aged 27) Internazionale
 11  FW  Arjen Robben         (1984-01-23)  (aged 28) Bayern Munich
 12  GK  Michel Vorm          (1983-10-20)  (aged 28) Swansea City
 13  DF  Ron Vlaar            (1985-02-16)  (aged 27) Feyenoord
 14  DF  Stijn Schaars        (1984-01-11)  (aged 28) Sporting
 15  DF  Jetro Willems        (1994-03-30)  (aged 18) PSV
 16  FW  Robin van Persie     (1983-08-06)  (aged 28) Arsenal
 17  MF  Kevin Strootman      (1990-02-13)  (aged 22) PSV
 18  FW  Luuk de Jong         (1990-08-27)  (aged 21) Twente
 19  FW  Luciano Narsingh     (1990-09-13)  (aged 21) Heerenveen
 20  FW  Ibrahim Afellay      (1986-04-02)  (aged 26) Barcelona
 21  DF  Khalid Boulahrouz    (1981-12-28)  (aged 30) VfB Stuttgart
 22  GK  Tim Krul             (1988-04-03)  (aged 24) Newcastle United
 23  MF  Rafael van der Vaart (1983-02-11)  (aged 29) Tottenham Hotspur

Denmark

Head coach:  Morten Olsen (Denmark)

  # Pos. Player              Date of Birth (Age)     Club
  1  GK  Kasper Schmeichel   (1986-11-05)  (aged 25) Leicester City
  2  MF  Christian Poulsen   (1980-02-28)  (aged 32) Evian
  3  DF  Simon Kjaer         (1989-03-26)  (aged 23) Roma
  4  DF  Daniel Agger (c)    (1984-12-12)  (aged 27) Liverpool
  5  DF  Simon Poulsen       (1984-10-07)  (aged 27) AZ
  6  DF  Lars Jacobsen       (1979-09-20)  (aged 32) Copenhagen
  7  MF  William Kvist       (1985-02-24)  (aged 27) VfB Stuttgart
  8  MF  Christian Eriksen   (1992-02-14)  (aged 20) Ajax
  9  FW  Michael Krohn-Dehli (1983-06-06)  (aged 29) Brondby
 10  FW  Dennis Rommedahl    (1978-07-22)  (aged 33) Brondby
 11  FW  Nicklas Bendtner    (1988-01-16)  (aged 24) Arsenal
 12  DF  Andreas Bjelland    (1988-07-11)  (aged 23) Nordsjaelland
 13  DF  Jores Okore         (1992-08-11)  (aged 19) Nordsjaelland
 14  MF  Lasse Schone        (1986-05-27)  (aged 26) NEC
 15  MF  Michael Silberbauer (1981-07-07)  (aged 30) Young Boys
 16  GK  Stephan Andersen    (1981-11-26)  (aged 30) Evian
 17  FW  Nicklas Pedersen    (1987-10-10)  (aged 24) Groningen
 18  DF  Daniel Wass         (1989-05-31)  (aged 23) Evian
 19  MF  Jakob Poulsen       (1983-07-07)  (aged 28) Midtjylland
 20  MF  Thomas Kahlenberg   (1983-03-20)  (aged 29) Evian
 21  MF  Niki Zimling        (1985-04-19)  (aged 27) Club Brugge
 22  GK  Anders Lindegaard   (1984-04-13)  (aged 28) Manchester United
 23  FW  Tobias Mikkelsen    (1986-09-18)  (aged 25) Nordsjaelland

Germany

Head coach:  Joachim Low (Germany)

  # Pos. Player                 Date of Birth (Age)     Club
  1  GK  Manuel Neuer           (1986-03-27)  (aged 26) Bayern Munich
  2  MF  Ilkay Gundogan         (1990-10-24)  (aged 21) Borussia Dortmund
  3  DF  Marcel Schmelzer       (1988-01-22)  (aged 24) Borussia Dortmund
  4  DF  Benedikt Howedes       (1988-02-29)  (aged 24) Schalke 04
  5  DF  Mats Hummels           (1988-12-16)  (aged 23) Borussia Dortmund
  6  MF  Sami Khedira           (1987-04-04)  (aged 25) Real Madrid
  7  MF  Bastian Schweinsteiger (1984-08-01)  (aged 27) Bayern Munich
  8  MF  Mesut Ozil             (1988-10-15)  (aged 23) Real Madrid
  9  MF  Andre Schurrle         (1990-11-06)  (aged 21) Bayer Leverkusen
 10  MF  Lukas Podolski         (1985-06-04)  (aged 27) Koln
 11  FW  Miroslav Klose         (1978-06-09)  (aged 33) Lazio
 12  GK  Tim Wiese              (1981-12-17)  (aged 30) Werder Bremen
 13  MF  Thomas Muller          (1989-09-13)  (aged 22) Bayern Munich
 14  DF  Holger Badstuber       (1989-03-13)  (aged 23) Bayern Munich
 15  MF  Lars Bender            (1989-04-27)  (aged 23) Bayer Leverkusen
 16  DF  Philipp Lahm (c)       (1983-11-11)  (aged 28) Bayern Munich
 17  DF  Per Mertesacker        (1984-09-29)  (aged 27) Arsenal
 18  MF  Toni Kroos             (1990-01-04)  (aged 22) Bayern Munich
 19  MF  Mario Gotze            (1992-06-03)  (aged 20) Borussia Dortmund
 20  DF  Jerome Boateng         (1988-09-03)  (aged 23) Bayern Munich
 21  MF  Marco Reus             (1989-05-31)  (aged 23) Borussia Mochengladbach
 22  GK  Ron-Robert Zieler      (1989-02-12)  (aged 23) Hannover 96
 23  FW  Mario Gomez            (1985-07-10)  (aged 26) Bayern Munich

Portugal

Head coach:  Paulo Bento (Portugal)

  # Pos. Player                Date of Birth (Age)     Club
  1  GK  Eduardo               (1982-09-19)  (aged 29) Benfica
  2  DF  Bruno Alves           (1981-11-27)  (aged 30) Zenit Saint Petersburg
  3  DF  Pepe                  (1983-02-26)  (aged 29) Real Madrid
  4  MF  Miguel Veloso         (1986-05-11)  (aged 26) Genoa
  5  DF  Fabio Coentrao        (1988-03-11)  (aged 24) Real Madrid
  6  MF  Custodio              (1983-05-24)  (aged 29) Braga
  7  FW  Cristiano Ronaldo (c) (1985-02-05)  (aged 27) Real Madrid
  8  MF  Joao Moutinho         (1986-09-08)  (aged 25) Porto
  9  FW  Hugo Almeida          (1984-05-23)  (aged 28) Besiktas
 10  FW  Ricardo Quaresma      (1983-09-26)  (aged 28) Besiktas
 11  FW  Nelson Oliveira       (1991-08-08)  (aged 20) Benfica
 12  GK  Rui Patricio          (1988-02-15)  (aged 24) Sporting CP
 13  DF  Ricardo Costa         (1981-05-16)  (aged 31) Valencia
 14  DF  Rolando               (1985-08-31)  (aged 26) Porto
 15  MF  Ruben Micael          (1986-08-19)  (aged 25) Atletico Madrid
 16  MF  Raul Meireles         (1983-03-17)  (aged 29) Chelsea
 17  FW  Nani                  (1986-11-17)  (aged 25) Manchester United
 18  FW  Silvestre Varela      (1985-02-02)  (aged 27) Porto
 19  DF  Miguel Lopes          (1986-12-19)  (aged 25) Braga
 20  MF  Hugo Viana            (1983-01-15)  (aged 29) Braga
 21  DF  Joao Pereira          (1984-02-25)  (aged 28) Sporting CP
 22  GK  Beto                  (1982-05-01)  (aged 30) CFR Cluj
 23  FW  Helder Postiga        (1982-08-02)  (aged 29) Real Zaragoza

 

答案见链接：

http://bbs.chinaunix.net/thread-3749971-1-1.html