|
csql> SELECT * FROM olympic;
csql> ;x
=== <Result of SELECT Command in Line 1> ===
host_year host_nation host_city opening_date closing_date mascot slogan introduction
==================================================================================================
2004 'Greece' 'Athens' 08/13/2004 08/29/2004 'Athena Phevos' 'Welcome Home' 'In 2004 the Olympic Games returned to Greece, the home of both the ancient Olympics and the first modern Olympics. For the first time ever a record 201 National Olympic Committees (NOCs) participated in the Olympic Games. The overall tally for events on the programme was 301 (one more than in Sydney 2000). Popularity in the Games soared to new highs as 3.9 billion people had access to the television coverage compared to 3.6 billion for Sydney 2000. Women''s wrestling was included in the program for the first time. Swimmer Michael Phelps won 6 gold medals and set a single-Games record with 8 total medals. Leontien Ziljaard-van Moorsel became the first female cyclist to earn 4 career gold medals and 6 total medals, while canoeist Birgit Fischer became the first athlete in any sport to win two medals in each of 5 Olympics. Runner Hicham El Guerrouj won both the 1,500m and the 5,000m, while on the women''s side Kelly Holmes triumphed in both the 800m and the 1,500m. In team play, Argentina won the men''s football tournament without giving up a goal, and the U.S. softball team won by outscoring their opponents 51-1.'
2000 'Australia' 'Sydney' 09/15/2000 10/01/2000 'Olly Syd Millie' 'Share the Spirit' 'The Sydney 2000 Games are the biggest to date with a total of 199 nations and more than 10,500 athletes participating. IOC President Juan Antonio Samaranch announced that the Games of the XXII Olympiad were the best Olympics ever held.'
1996 'USA' 'Atlanta' 07/19/1996 08/09/1996 'Izzy' 'The Celebration of the Century' 'The 1996 Atlanta Games celebrated 100 years of the Modern Olympic Games. In 100 years the Games had grown from thirteen to 197 competing nations, from 300 male athletes to more than 10,000 male and female athletes and from 43 to 271 events. During these Games a terrorist bomb at a concert killed one person and injured more than 100 people.'
1992 'Spain' 'Barcelona' 07/25/1992 08/09/1992 'Cobi' 'Friends Forever' 'For the first time in decades, no nations boycotted the 1992 Barcelona Games. The Olympic Truce was recited for the first time with 169 countries and nearly 10,000 athletes participating in the Olympics.'
1988 'Korea' 'Seoul' 09/17/1988 10/02/1988 'HODORI' 'Harmony and progress' 'The 1988 Seoul Games were the first Olympics to allow professional athletes to compete in certain events. The IOC refused to give North Korea the title of co-hosts so they boycotted the Games. This resulted in a couple of other nations boycotting the event in support of North Korea.'
1984 'USA' 'Los Angeles' 07/28/1984 08/12/1984 'Sam' 'Play part in History' 'For the first time since 1952, China sent athletes to the Games. The Soviet Union and some of its allies withdrew their athletes citing that security was not good enough. 140 countries competed at the 1984 Los Angeles Games with over 1500 women, 5000 men and nearly 10,000 media attending the Games.'
1980 'USSR' 'Moscow' 07/19/1980 08/03/1980 'Misha' '' 'These were the first Games to be held in a socialist country and due to the 1979 Soviet invasion of Afghanistan, dozens of nations boycotted the 1980 Moscow Games. The number of competing nations had not been so low since the 1956 Melbourne Games. That said, there were more than 1000 women and 4000 men competing at these Games.'
1976 'Canada' 'Montreal' 07/17/1976 08/01/1976 'Amik' '' 'Due to an earlier tour of apartheid South Africa by a New Zealand rugby union team, the 1976 Montreal Games were plagued with African countries boycotting the competition due to New Zealand's Olympic presence. Taiwan also boycotted as it was not acknowledged as part of the Republic of China bt the IOC.'
······
25 rows selected.
Current transaction has been committed.
1 command(s) successfully processed.
|
qualifier : 한정어. 생략이 가능하며 지정하지 않을 경우에는 ALL로 지정된다.
