首页 > 代码库 > 2016.9.26小程序---数据库练习2

2016.9.26小程序---数据库练习2

  1 -- createnobel, 1, 50  2 DROP TABLE nobel;  3 CREATE TABLE nobel(  4   yr INT   -- 年份  5  ,SUBJECT VARCHAR(15) -- 奖项  6  ,winner VARCHAR(50)  -- 获奖者  7 )DEFAULT CHARSET=utf8;  8   9 GO 10 -- tabnobel, 1, 50 11 INSERT INTO nobel VALUES (1901,Chemistry,Jacobus H. van t Hoff); 12 INSERT INTO nobel VALUES (1902,Chemistry,Emil Fischer); 13 INSERT INTO nobel VALUES (1903,Chemistry,Svante Arrhenius); 14 INSERT INTO nobel VALUES (1904,Chemistry,Sir William Ramsay); 15 INSERT INTO nobel VALUES (1905,Chemistry,Adolf von Baeyer); 16 INSERT INTO nobel VALUES (1906,Chemistry,Henri Moissan); 17 INSERT INTO nobel VALUES (1907,Chemistry,Eduard Buchner); 18 INSERT INTO nobel VALUES (1908,Chemistry,Ernest Rutherford); 19 INSERT INTO nobel VALUES (1909,Chemistry,Wilhelm Ostwald); 20 INSERT INTO nobel VALUES (1910,Chemistry,Otto Wallach); 21 INSERT INTO nobel VALUES (1911,Chemistry,Marie Curie); 22 INSERT INTO nobel VALUES (1912,Chemistry,Victor Grignard); 23 INSERT INTO nobel VALUES (1912,Chemistry,Paul Sabatier); 24 INSERT INTO nobel VALUES (1913,Chemistry,Alfred Werner); 25 INSERT INTO nobel VALUES (1914,Chemistry,Theodore W. Richards); 26 INSERT INTO nobel VALUES (1915,Chemistry,Richard Willst?¤er); 27 INSERT INTO nobel VALUES (1918,Chemistry,Fritz Haber); 28 INSERT INTO nobel VALUES (1920,Chemistry,Walther Nernst); 29 INSERT INTO nobel VALUES (1921,Chemistry,Frederick Soddy); 30 INSERT INTO nobel VALUES (1922,Chemistry,Francis W. Aston); 31 INSERT INTO nobel VALUES (1923,Chemistry,Fritz Pregl); 32 INSERT INTO nobel VALUES (1925,Chemistry,Richard Zsigmondy); 33 INSERT INTO nobel VALUES (1926,Chemistry,The Svedberg); 34 INSERT INTO nobel VALUES (1927,Chemistry,Heinrich Wieland); 35 INSERT INTO nobel VALUES (1928,Chemistry,Adolf Windaus); 36 INSERT INTO nobel VALUES (1929,Chemistry,Arthur Harden); 37 INSERT INTO nobel VALUES (1929,Chemistry,Hans von Euler-Chelpin); 38 INSERT INTO nobel VALUES (1930,Chemistry,Hans Fischer); 39 INSERT INTO nobel VALUES (1931,Chemistry,Friedrich Bergius); 40 INSERT INTO nobel VALUES (1931,Chemistry,Carl Bosch); 41 INSERT INTO nobel VALUES (1932,Chemistry,Irving Langmuir); 42 INSERT INTO nobel VALUES (1934,Chemistry,Harold C. Urey); 43 INSERT INTO nobel VALUES (1935,Chemistry,Fraric Joliot); 44 INSERT INTO nobel VALUES (1935,Chemistry,Ire Joliot-Curie); 45 INSERT INTO nobel VALUES (1936,Chemistry,Peter Debye); 46 INSERT INTO nobel VALUES (1937,Chemistry,Norman Haworth); 47 INSERT INTO nobel VALUES (1937,Chemistry,Paul Karrer); 48 INSERT INTO nobel VALUES (1938,Chemistry,Richard Kuhn); 49 INSERT INTO nobel VALUES (1939,Chemistry,Adolf Butenandt); 50 INSERT INTO nobel VALUES (1939,Chemistry,Leopold Ruzicka); 51 INSERT INTO nobel VALUES (1943,Chemistry,George de Hevesy); 52 INSERT INTO nobel VALUES (1944,Chemistry,Otto Hahn); 53 INSERT INTO nobel VALUES (1945,Chemistry,Artturi Virtanen); 54 INSERT INTO nobel VALUES (1946,Chemistry,John H. Northrop); 55 INSERT INTO nobel VALUES (1946,Chemistry,Wendell M. Stanley); 56 INSERT INTO nobel VALUES (1946,Chemistry,James B.mner); 57 INSERT INTO nobel VALUES (1947,Chemistry,Sir Robert Robinson); 58 INSERT INTO nobel VALUES (1948,Chemistry,Arne Tiselius); 59 INSERT INTO nobel VALUES (1949,Chemistry,William F. Giauque); 60 INSERT INTO nobel VALUES (1950,Chemistry,Kurt Alder); 61 -- tabnobel, 51, 50 62 INSERT INTO nobel VALUES (1950,Chemistry,Otto Diels); 63 INSERT INTO nobel VALUES (1951,Chemistry,Edwin M. McMillan); 64 INSERT INTO nobel VALUES (1951,Chemistry,Glenn T. Seaborg); 65 INSERT INTO nobel VALUES (1952,Chemistry,Archer J.P. Martin); 66 INSERT INTO nobel VALUES (1952,Chemistry,Richard L.M. Synge); 67 INSERT INTO nobel VALUES (1953,Chemistry,Hermann Staudinger); 68 INSERT INTO nobel VALUES (1954,Chemistry,Linus Pauling); 69 INSERT INTO nobel VALUES (1955,Chemistry,Vincent du Vigneaud); 70 INSERT INTO nobel VALUES (1956,Chemistry,Sir Cyril Hinshelwood); 71 INSERT INTO nobel VALUES (1956,Chemistry,Nikolay Semenov); 72 INSERT INTO nobel VALUES (1957,Chemistry,Lord Todd); 73 INSERT INTO nobel VALUES (1958,Chemistry,Frederick Sanger); 74 INSERT INTO nobel VALUES (1959,Chemistry,Jaroslav Heyrovsky); 75 INSERT INTO nobel VALUES (1960,Chemistry,Willard F. Libby); 76 INSERT INTO nobel VALUES (1961,Chemistry,Melvin Calvin); 77 INSERT INTO nobel VALUES (1962,Chemistry,John C. Kendrew); 78 INSERT INTO nobel VALUES (1962,Chemistry,Max F. Perutz); 79 INSERT INTO nobel VALUES (1963,Chemistry,Giulio Natta); 80 INSERT INTO nobel VALUES (1963,Chemistry,Karl Ziegler); 81 INSERT INTO nobel VALUES (1964,Chemistry,Dorothy Crowfoot Hodgkin); 82 INSERT INTO nobel VALUES (1965,Chemistry,Robert B. Woodward); 83 INSERT INTO nobel VALUES (1966,Chemistry,Robert S. Mulliken); 84 INSERT INTO nobel VALUES (1967,Chemistry,Manfred Eigen); 85 INSERT INTO nobel VALUES (1967,Chemistry,Ronald G.W. Norrish); 86 INSERT INTO nobel VALUES (1967,Chemistry,George Porter); 87 INSERT INTO nobel VALUES (1968,Chemistry,Lars Onsager); 88 INSERT INTO nobel VALUES (1969,Chemistry,Derek Barton); 89 INSERT INTO nobel VALUES (1969,Chemistry,Odd Hassel); 90 INSERT INTO nobel VALUES (1970,Chemistry,Luis Leloir); 91 INSERT INTO nobel VALUES (1971,Chemistry,Gerhard Herzberg); 92 INSERT INTO nobel VALUES (1972,Chemistry,Christian Anfinsen); 93 INSERT INTO nobel VALUES (1972,Chemistry,Stanford Moore); 94 INSERT INTO nobel VALUES (1972,Chemistry,William H. Stein); 95 INSERT INTO nobel VALUES (1973,Chemistry,Ernst Otto Fischer); 96 INSERT INTO nobel VALUES (1973,Chemistry,Geoffrey Wilkinson); 97 INSERT INTO nobel VALUES (1974,Chemistry,Paul J. Flory); 98 INSERT INTO nobel VALUES (1975,Chemistry,John Cornforth); 99 INSERT INTO nobel VALUES (1975,Chemistry,Vladimir Prelog);100 INSERT INTO nobel VALUES (1976,Chemistry,William Lipscomb);101 INSERT INTO nobel VALUES (1977,Chemistry,Ilya Prigogine);102 INSERT INTO nobel VALUES (1978,Chemistry,Peter Mitchell);103 INSERT INTO nobel VALUES (1979,Chemistry,Herbert C. Brown);104 INSERT INTO nobel VALUES (1979,Chemistry,Georg Wittig);105 INSERT INTO nobel VALUES (1980,Chemistry,Paul Berg);106 INSERT INTO nobel VALUES (1980,Chemistry,Walter Gilbert);107 INSERT INTO nobel VALUES (1980,Chemistry,Frederick Sanger);108 INSERT INTO nobel VALUES (1981,Chemistry,Kenichi Fukui);109 INSERT INTO nobel VALUES (1981,Chemistry,Roald Hoffmann);110 INSERT INTO nobel VALUES (1982,Chemistry,Aaron Klug);111 INSERT INTO nobel VALUES (1983,Chemistry,Henry Taube);112 -- tabnobel, 101, 50113 INSERT INTO nobel VALUES (1984,Chemistry,Bruce Merrifield);114 INSERT INTO nobel VALUES (1985,Chemistry,Herbert A. Hauptman);115 INSERT INTO nobel VALUES (1985,Chemistry,Jerome Karle);116 INSERT INTO nobel VALUES (1986,Chemistry,Dudley R. Herschbach);117 INSERT INTO nobel VALUES (1986,Chemistry,Yuan T. Lee);118 INSERT INTO nobel VALUES (1986,Chemistry,John C. Polanyi);119 INSERT INTO nobel VALUES (1987,Chemistry,Donald J. Cram);120 INSERT INTO nobel VALUES (1987,Chemistry,Jean-Marie Lehn);121 INSERT INTO nobel VALUES (1987,Chemistry,Charles J. Pedersen);122 INSERT INTO nobel VALUES (1988,Chemistry,Johann Deisenhofer);123 INSERT INTO nobel VALUES (1988,Chemistry,Robert Huber);124 INSERT INTO nobel VALUES (1988,Chemistry,Hartmut Michel);125 INSERT INTO nobel VALUES (1989,Chemistry,Sidney Altman);126 INSERT INTO nobel VALUES (1989,Chemistry,Thomas R. Cech);127 INSERT INTO nobel VALUES (1990,Chemistry,Elias James Corey);128 INSERT INTO nobel VALUES (1991,Chemistry,Richard R. Ernst);129 INSERT INTO nobel VALUES (1992,Chemistry,Rudolph A. Marcus);130 INSERT INTO nobel VALUES (1993,Chemistry,Kary B. Mullis);131 INSERT INTO nobel VALUES (1993,Chemistry,Michael Smith);132 INSERT INTO nobel VALUES (1994,Chemistry,George A. Olah);133 INSERT INTO nobel VALUES (1995,Chemistry,Paul J. Crutzen);134 INSERT INTO nobel VALUES (1995,Chemistry,Mario J. Molina);135 INSERT INTO nobel VALUES (1995,Chemistry,F. Sherwood Rowland);136 INSERT INTO nobel VALUES (1996,Chemistry,Robert F. Curl Jr.);137 INSERT INTO nobel VALUES (1996,Chemistry,Sir Harold Kroto);138 INSERT INTO nobel VALUES (1996,Chemistry,Richard E. Smalley);139 INSERT INTO nobel VALUES (1997,Chemistry,Paul D. Boyer);140 INSERT INTO nobel VALUES (1997,Chemistry,Jens C. Skou);141 INSERT INTO nobel VALUES (1997,Chemistry,John E. Walker);142 INSERT INTO nobel VALUES (1998,Chemistry,Walter Kohn);143 INSERT INTO nobel VALUES (1998,Chemistry,John Pople);144 INSERT INTO nobel VALUES (1999,Chemistry,Ahmed Zewail);145 INSERT INTO nobel VALUES (2000,Chemistry,Alan Heeger);146 INSERT INTO nobel VALUES (2000,Chemistry,Alan G. MacDiarmid);147 INSERT INTO nobel VALUES (2000,Chemistry,Hideki Shirakawa);148 INSERT INTO nobel VALUES (2001,Chemistry,William S. Knowles);149 INSERT INTO nobel VALUES (2001,Chemistry,Ryoji Noyori);150 INSERT INTO nobel VALUES (2001,Chemistry,K. Barry Sharpless);151 INSERT INTO nobel VALUES (2002,Chemistry,John B. Fenn);152 INSERT INTO nobel VALUES (2002,Chemistry,Koichi Tanaka);153 INSERT INTO nobel VALUES (2002,Chemistry,Kurt Wah);154 INSERT INTO nobel VALUES (2003,Chemistry,Peter Agre);155 INSERT INTO nobel VALUES (2003,Chemistry,Roderick MacKinnon);156 INSERT INTO nobel VALUES (2004,Chemistry,Aaron Ciechanover);157 INSERT INTO nobel VALUES (2004,Chemistry,Avram Hershko);158 INSERT INTO nobel VALUES (2004,Chemistry,Irwin Rose);159 INSERT INTO nobel VALUES (2005,Chemistry,Yves Chauvin);160 INSERT INTO nobel VALUES (2005,Chemistry,Robert H. Grubbs);161 INSERT INTO nobel VALUES (2005,Chemistry,Richard R. Schrock);162 INSERT INTO nobel VALUES (1969,Economics,Ragnar Frisch);163 -- tabnobel, 151, 50164 INSERT INTO nobel VALUES (1969,Economics,Jan Tinbergen);165 INSERT INTO nobel VALUES (1970,Economics,Paul A. Samuelson);166 INSERT INTO nobel VALUES (1971,Economics,Simon Kuznets);167 INSERT INTO nobel VALUES (1972,Economics,Kenneth J. Arrow);168 INSERT INTO nobel VALUES (1972,Economics,John R. Hicks);169 INSERT INTO nobel VALUES (1973,Economics,Wassily Leontief);170 INSERT INTO nobel VALUES (1974,Economics,Gunnar Myrdal);171 INSERT INTO nobel VALUES (1974,Economics,Friedrich August von Hayek);172 INSERT INTO nobel VALUES (1975,Economics,Leonid Vitaliyevich Kantorovich);173 INSERT INTO nobel VALUES (1975,Economics,Tjalling C. Koopmans);174 INSERT INTO nobel VALUES (1976,Economics,Milton Friedman);175 INSERT INTO nobel VALUES (1977,Economics,James E. Meade);176 INSERT INTO nobel VALUES (1977,Economics,Bertil Ohlin);177 INSERT INTO nobel VALUES (1978,Economics,Herbert A. Simon);178 INSERT INTO nobel VALUES (1979,Economics,Sir Arthur Lewis);179 INSERT INTO nobel VALUES (1979,Economics,Theodore W. Schultz);180 INSERT INTO nobel VALUES (1980,Economics,Lawrence R. Klein);181 INSERT INTO nobel VALUES (1981,Economics,James Tobin);182 INSERT INTO nobel VALUES (1982,Economics,George J. Stigler);183 INSERT INTO nobel VALUES (1983,Economics,Gerard Debreu);184 INSERT INTO nobel VALUES (1984,Economics,Richard Stone);185 INSERT INTO nobel VALUES (1985,Economics,Franco Modigliani);186 INSERT INTO nobel VALUES (1986,Economics,James M. hanan Jr.);187 INSERT INTO nobel VALUES (1987,Economics,Robert M. Solow);188 INSERT INTO nobel VALUES (1988,Economics,Maurice Allais);189 INSERT INTO nobel VALUES (1989,Economics,Trygve Haavelmo);190 INSERT INTO nobel VALUES (1990,Economics,Harry M. Markowitz);191 INSERT INTO nobel VALUES (1990,Economics,Merton H. Miller);192 INSERT INTO nobel VALUES (1990,Economics,William F. Sharpe);193 INSERT INTO nobel VALUES (1991,Economics,Ronald H. Coase);194 INSERT INTO nobel VALUES (1992,Economics,Gary S. Becker);195 INSERT INTO nobel VALUES (1993,Economics,Robert W. Fogel);196 INSERT INTO nobel VALUES (1993,Economics,Douglass C. North);197 INSERT INTO nobel VALUES (1994,Economics,John C. Harsanyi);198 INSERT INTO nobel VALUES (1994,Economics,John F. Nash Jr.);199 INSERT INTO nobel VALUES (1994,Economics,Reinhard Selten);200 INSERT INTO nobel VALUES (1995,Economics,Robert E. Lucas Jr.);201 INSERT INTO nobel VALUES (1996,Economics,James A. Mirrlees);202 INSERT INTO nobel VALUES (1996,Economics,William Vickrey);203 INSERT INTO nobel VALUES (1997,Economics,Robert C. Merton);204 INSERT INTO nobel VALUES (1997,Economics,Myron S. Scholes);205 INSERT INTO nobel VALUES (1998,Economics,Amartya Sen);206 INSERT INTO nobel VALUES (1999,Economics,Robert A. Mundell);207 INSERT INTO nobel VALUES (2000,Economics,James J. Heckman);208 INSERT INTO nobel VALUES (2000,Economics,Daniel L. McFadden);209 INSERT INTO nobel VALUES (2001,Economics,George A. Akerlof);210 INSERT INTO nobel VALUES (2001,Economics,A. Michael Spence);211 INSERT INTO nobel VALUES (2001,Economics,Joseph E. Stiglitz);212 INSERT INTO nobel VALUES (2002,Economics,Daniel Kahneman);213 INSERT INTO nobel VALUES (2002,Economics,Vernon L. Smith);214 -- tabnobel, 201, 50215 INSERT INTO nobel VALUES (2003,Economics,Robert F. Engle III);216 INSERT INTO nobel VALUES (2003,Economics,Clive W.J. Granger);217 INSERT INTO nobel VALUES (2004,Economics,Finn E. Kydland);218 INSERT INTO nobel VALUES (2004,Economics,Edward C. Prett);219 INSERT INTO nobel VALUES (2005,Economics,Robert J. Aumann);220 INSERT INTO nobel VALUES (2005,Economics,Thomas C. Schelling);221 INSERT INTO nobel VALUES (1901,Literature,Sully Prudhomme);222 INSERT INTO nobel VALUES (1902,Literature,Theodor Mommsen);223 INSERT INTO nobel VALUES (1903,Literature,Bjce jerne Bjcn);224 INSERT INTO nobel VALUES (1904,Literature,Josae chegaray);225 INSERT INTO nobel VALUES (1904,Literature,Fraric Mistral);226 INSERT INTO nobel VALUES (1905,Literature,Henryk Sienkiewicz);227 INSERT INTO nobel VALUES (1906,Literature,Giosu?¨arducci);228 INSERT INTO nobel VALUES (1907,Literature,Rudyard Kipling);229 INSERT INTO nobel VALUES (1908,Literature,Rudolf Eucken);230 INSERT INTO nobel VALUES (1909,Literature,Selma Lagerlce);231 INSERT INTO nobel VALUES (1910,Literature,Paul Heyse);232 INSERT INTO nobel VALUES (1911,Literature,Maurice Maeterlinck);233 INSERT INTO nobel VALUES (1912,Literature,Gerhart Hauptmann);234 INSERT INTO nobel VALUES (1913,Literature,Rabindranath Tagore);235 INSERT INTO nobel VALUES (1915,Literature,Romain Rolland);236 INSERT INTO nobel VALUES (1916,Literature,Verner von Heidenstam);237 INSERT INTO nobel VALUES (1917,Literature,Karl Gjellerup);238 INSERT INTO nobel VALUES (1917,Literature,Henrik Pontoppidan);239 INSERT INTO nobel VALUES (1919,Literature,Carl Spitteler);240 INSERT INTO nobel VALUES (1920,Literature,Knut Hamsun);241 INSERT INTO nobel VALUES (1921,Literature,Anatole France);242 INSERT INTO nobel VALUES (1922,Literature,Jacinto Benavente);243 INSERT INTO nobel VALUES (1923,Literature,William Butler Yeats);244 INSERT INTO nobel VALUES (1924,Literature,Wladyslaw Reymont);245 INSERT INTO nobel VALUES (1925,Literature,George Bernard Shaw);246 INSERT INTO nobel VALUES (1926,Literature,Grazia Deledda);247 INSERT INTO nobel VALUES (1927,Literature,Henri Bergson);248 INSERT INTO nobel VALUES (1928,Literature,Sigrid Undset);249 INSERT INTO nobel VALUES (1929,Literature,Thomas Mann);250 INSERT INTO nobel VALUES (1930,Literature,Sinclair Lewis);251 INSERT INTO nobel VALUES (1931,Literature,Erik Axel Karlfeldt);252 INSERT INTO nobel VALUES (1932,Literature,John Galsworthy);253 INSERT INTO nobel VALUES (1933,Literature,Ivan Bunin);254 INSERT INTO nobel VALUES (1934,Literature,Luigi Pirandello);255 INSERT INTO nobel VALUES (1936,Literature,Eugene O‘‘Neill);256 INSERT INTO nobel VALUES (1937,Literature,Roger Martin du Gard);257 INSERT INTO nobel VALUES (1938,Literature,Pearl Buck);258 INSERT INTO nobel VALUES (1939,Literature,Frans Eemil Sillanpce);259 INSERT INTO nobel VALUES (1944,Literature,Johannes V. Jensen);260 INSERT INTO nobel VALUES (1945,Literature,Gabriela Mistral);261 INSERT INTO nobel VALUES (1946,Literature,Hermann Hesse);262 INSERT INTO nobel VALUES (1947,Literature,Andraide);263 INSERT INTO nobel VALUES (1948,Literature,T.S. Eliot);264 INSERT INTO nobel VALUES (1949,Literature,William Faulkner);265 -- tabnobel, 251, 50266 INSERT INTO nobel VALUES (1950,Literre,Bertrand Russell);267 INSERT INTO nobel VALUES (1951,Literature,PicLagerkvist);268 INSERT INTO nobel VALUES (1952,Literature,France Mauriac);269 INSERT INTO nobel VALUES (1953,Literature,Winston Churchill);270 INSERT INTO nobel VALUES (1954,Literature,Ernest Hemingway);271 INSERT INTO nobel VALUES (1955,Literature,Halld maxness);272 INSERT INTO nobel VALUES (1956,Literature,Juan Rameaimsz);273 INSERT INTO nobel VALUES (1957,Literature,Albert Camus);274 INSERT INTO nobel VALUES (1958,Literature,Boris Pasternak);275 INSERT INTO nobel VALUES (1959,Literature,Salvatore Quasimodo);276 INSERT INTO nobel VALUES (1960,Literature,Saint-John Perse);277 INSERT INTO nobel VALUES (1961,Literature,Ivo Andric);278 INSERT INTO nobel VALUES (1962,Literature,John Steinbeck);279 INSERT INTO nobel VALUES (1963,Literature,Giorgos Seferis);280 INSERT INTO nobel VALUES (1964,Literature,Jean-Paul Sartre);281 INSERT INTO nobel VALUES (1965,Literature,Mikhail Sholokhov);282 INSERT INTO nobel VALUES (1966,Literature,Samuel Agnon);283 INSERT INTO nobel VALUES (1966,Literature,Nelly Sachs);284 INSERT INTO nobel VALUES (1967,Literature,Miguel Angel Asturias);285 INSERT INTO nobel VALUES (1968,Literature,Yasunari Kawabata);286 INSERT INTO nobel VALUES (1969,Literature,Samuel Beckett);287 INSERT INTO nobel VALUES (1970,Literature,Alexandr Solzhenitsyn);288 INSERT INTO nobel VALUES (1971,Literature,Pablo Neruda);289 INSERT INTO nobel VALUES (1972,Literature,Heinrich B??ll);290 INSERT INTO nobel VALUES (1973,Literature,Patrick White);291 INSERT INTO nobel VALUES (1974,Literature,Eyvind Johnson);292 INSERT INTO nobel VALUES (1974,Literature,Harry Martinson);293 INSERT INTO nobel VALUES (1975,Literature,Eugenio Montale);294 INSERT INTO nobel VALUES (1976,Literature,Saul Bellow);295 INSERT INTO nobel VALUES (1977,Literature,Vicente Aleixandre);296 INSERT INTO nobel VALUES (1978,Literature,Isaac Bashevis Singer);297 INSERT INTO nobel VALUES (1979,Literature,Odysseus Elytis);298 INSERT INTO nobel VALUES (1980,Literature,Czeslaw Milosz);299 INSERT INTO nobel VALUES (1981,Literature,Elias Canetti);300 INSERT INTO nobel VALUES (1982,Literature,Gabriel Garc?-M??uez);301 INSERT INTO nobel VALUES (1983,Literature,William Golding);302 INSERT INTO nobel VALUES (1984,Literature,Jaroslav Seifert);303 INSERT INTO nobel VALUES (1985,Literature,Claude Simon);304 INSERT INTO nobel VALUES (1986,Literature,Wole Soyinka);305 INSERT INTO nobel VALUES (1987,Literature,Joseph Brodsky);306 INSERT INTO nobel VALUES (1988,Literature,Naguib Mahfouz);307 INSERT INTO nobel VALUES (1989,Literature,Camilo Jos??ela);308 INSERT INTO nobel VALUES (1990,Literature,Octavio Paz);309 INSERT INTO nobel VALUES (1991,Literature,Nadine Gordimer);310 INSERT INTO nobel VALUES (1992,Literature,Derek Walcott);311 INSERT INTO nobel VALUES (1993,Literature,Toni Morrison);312 INSERT INTO nobel VALUES (1994,Literature,Kenzaburo Oe);313 INSERT INTO nobel VALUES (1995,Literature,Seamus Heaney);314 INSERT INTO nobel VALUES (1996,Literature,Wislawa Szymborska);315 INSERT INTO nobel VALUES (1997,Literature,Dario Fo);316 -- tabnobel, 301, 50317 INSERT INTO nobel VALUES (1998,Literature,Jos varamago);318 INSERT INTO nobel VALUES (1999,Literature,GaGrass);319 INSERT INTO nobel VALUES (2000,Literature,Gao Xingjian);320 INSERT INTO nobel VALUES (2001,Literature,V.S. Naipaul);321 INSERT INTO nobel VALUES (2002,Literature,Imre Kertic);322 INSERT INTO nobel VALUES (2003,Literature,J.M. Coetzee);323 INSERT INTO nobel VALUES (2004,Literature,Elfriede Jelinek);324 INSERT INTO nobel VALUES (2005,Literature,Harold Pinter);325 INSERT INTO nobel VALUES (1901,Medicine,Emil von Behring);326 INSERT INTO nobel VALUES (1902,Medicine,Ronald Ross);327 INSERT INTO nobel VALUES (1903,Medicine,Niels Ryberg Finsen);328 INSERT INTO nobel VALUES (1904,Medicine,Ivan Pavlov);329 INSERT INTO nobel VALUES (1905,Medicine,Robert Koch);330 INSERT INTO nobel VALUES (1906,Medicine,Camillo Golgi);331 INSERT INTO nobel VALUES (1906,Medicine,Santiago Ramte Cajal);332 INSERT INTO nobel VALUES (1907,Medicine,Alphonse Laveran);333 INSERT INTO nobel VALUES (1908,Medicine,Paul Ehrlich);334 INSERT INTO nobel VALUES (1908,Medicine,Ilya Mechnikov);335 INSERT INTO nobel VALUES (1909,Medicine,Theodor Kocher);336 INSERT INTO nobel VALUES (1910,Medicine,Albrecht Kossel);337 INSERT INTO nobel VALUES (1911,Medicine,Allvar Gullstrand);338 INSERT INTO nobel VALUES (1912,Medicine,Alexis Carrel);339 INSERT INTO nobel VALUES (1913,Medicine,Charles Richet);340 INSERT INTO nobel VALUES (1914,Medicine,Robert Bany);341 INSERT INTO nobel VALUES (1919,Medicine,Jules Bordet);342 INSERT INTO nobel VALUES (1920,Medicine,August Krogh);343 INSERT INTO nobel VALUES (1922,Medicine,Archibald V. Hill);344 INSERT INTO nobel VALUES (1922,Medicine,Otto Meyerhof);345 INSERT INTO nobel VALUES (1923,Medicine,Frederick G. Banting);346 INSERT INTO nobel VALUES (1923,Medicine,John Macleod);347 INSERT INTO nobel VALUES (1924,Medicine,Willem Einthoven);348 INSERT INTO nobel VALUES (1926,Medicine,Johannes Fibiger);349 INSERT INTO nobel VALUES (1927,Medicine,Julius Wagner-Jauregg);350 INSERT INTO nobel VALUES (1928,Medicine,Charles Nicolle);351 INSERT INTO nobel VALUES (1929,Medicine,Christiaan Eijkman);352 INSERT INTO nobel VALUES (1929,Medicine,Sir Frederick Hopkins);353 INSERT INTO nobel VALUES (1930,Medicine,Karl Landsteiner);354 INSERT INTO nobel VALUES (1931,Medicine,Otto Warburg);355 INSERT INTO nobel VALUES (1932,Medicine,Edgar Adrian);356 INSERT INTO nobel VALUES (1932,Medicine,Sir Charles Sherrington);357 INSERT INTO nobel VALUES (1933,Medicine,Thomas H. Morgan);358 INSERT INTO nobel VALUES (1934,Medicine,George R. Minot);359 INSERT INTO nobel VALUES (1934,Medicine,William P. Murphy);360 INSERT INTO nobel VALUES (1934,Medicine,George H. Whipple);361 INSERT INTO nobel VALUES (1935,Medicine,Hans Spemann);362 INSERT INTO nobel VALUES (1936,Medicine,Sir Henry Dale);363 INSERT INTO nobel VALUES (1936,Medicine,Otto Loewi);364 INSERT INTO nobel VALUES (1937,Medicine,Albert Szent-Gyli);365 INSERT INTO nobel VALUES (1938,Medicine,Corneille Heymans);366 INSERT INTO nobel VALUES (1939,Medicine,Gerhard Domagk);367 -- tabnobel, 351, 50368 INSERT INTO nobel VALUES (1943,Medicine,Henrik Dam);369 INSERT INTO nobel VALUES (1943,Medicine,Edward A. Doisy);370 INSERT INTO nobel VALUES (1944,Medicine,Joseph Erlanger);371 INSERT INTO nobel VALUES (1944,Medicine,Herbert S. Gasser);372 INSERT INTO nobel VALUES (1945,Medicine,Ernst B. Chain);373 INSERT INTO nobel VALUES (1945,Medicine,Sir Alexander Fleming);374 INSERT INTO nobel VALUES (1945,Medicine,Sir Howard Florey);375 INSERT INTO nobel VALUES (1946,Medicine,Hermann J. Muller);376 INSERT INTO nobel VALUES (1947,Medicine,Carl Cori);377 INSERT INTO nobel VALUES (1947,Medicine,Gerty Cori);378 INSERT INTO nobel VALUES (1947,Medicine,Bernardo Houssay);379 INSERT INTO nobel VALUES (1948,Medicine,Paul Maller);380 INSERT INTO nobel VALUES (1949,Medicine,Walter Hess);381 INSERT INTO nobel VALUES (1949,Medicine,Egas Moniz);382 INSERT INTO nobel VALUES (1950,Medicine,Philip S. Hench);383 INSERT INTO nobel VALUES (1950,Medicine,Edward C. Kendall);384 INSERT INTO nobel VALUES (1950,Medicine,Tadeus Reichstein);385 INSERT INTO nobel VALUES (1951,Medicine,Max Theiler);386 INSERT INTO nobel VALUES (1952,Medicine,Selman A. Waksman);387 INSERT INTO nobel VALUES (1953,Medicine,Hans Krebs);388 INSERT INTO nobel VALUES (1953,Medicine,Fritz Lipmann);389 INSERT INTO nobel VALUES (1954,Medicine,John F. Enders);390 INSERT INTO nobel VALUES (1954,Medicine,Frederick C. Robbins);391 INSERT INTO nobel VALUES (1954,Medicine,Thomas H. Weller);392 INSERT INTO nobel VALUES (1955,Medicine,Hugo Theorell);393 INSERT INTO nobel VALUES (1956,Medicine,Andra. Cournand);394 INSERT INTO nobel VALUES (1956,Medicine,Werner Forssmann);395 INSERT INTO nobel VALUES (1956,Medicine,Dickinson W. Richards);396 INSERT INTO nobel VALUES (1957,Medicine,Daniel Bo);397 INSERT INTO nobel VALUES (1958,Medicine,George Beadle);398 INSERT INTO nobel VALUES (1958,Medicine,Joshua Lederberg);399 INSERT INTO nobel VALUES (1958,Medicine,Edward Tatum);400 INSERT INTO nobel VALUES (1959,Medicine,Arthur Kornberg);401 INSERT INTO nobel VALUES (1959,Medicine,Severo Ochoa);402 INSERT INTO nobel VALUES (1960,Medicine,Sir Frank Macfarlane Burnet);403 INSERT INTO nobel VALUES (1960,Medicine,Peter Medawar);404 INSERT INTO nobel VALUES (1961,Medicine,Georg von Besy);405 INSERT INTO nobel VALUES (1962,Medicine,Francis Crick);406 INSERT INTO nobel VALUES (1962,Medicine,James Watson);407 INSERT INTO nobel VALUES (1962,Medicine,Maurice Wilkins);408 INSERT INTO nobel VALUES (1963,Medicine,Sir John Eccles);409 INSERT INTO nobel VALUES (1963,Medicine,Alan L. Hodgkin);410 INSERT INTO nobel VALUES (1963,Medicine,Andrew F. Huxley);411 INSERT INTO nobel VALUES (1964,Medicine,Konrad Bloch);412 INSERT INTO nobel VALUES (1964,Medicine,Feodor Lynen);413 INSERT INTO nobel VALUES (1965,Medicine,France Jacob);414 INSERT INTO nobel VALUES (1965,Medicine,Andrawoff);415 INSERT INTO nobel VALUES (1965,Medicine,Jacques Monod);416 INSERT INTO nobel VALUES (1966,Medicine,Charles B. Huggins);417 INSERT INTO nobel VALUES (1966,Medicine,Peyton Rous);418 -- tabnobel, 401, 50419 INSERT INTO nobel VALUES (1967,Medicine,Ragnar Granit);420 INSERT INTO nobel VALUES (1967,Medicine,Haldan K. Hartline);421 INSERT INTO nobel VALUES (1967,Medicine,George Wald);422 INSERT INTO nobel VALUES (1968,Medicine,Robert W. Holley);423 INSERT INTO nobel VALUES (1968,Medicine,H. Gobind Khorana);424 INSERT INTO nobel VALUES (1968,Medicine,Marshall W. Nirenberg);425 INSERT INTO nobel VALUES (1969,Medicine,Max Delbrack);426 INSERT INTO nobel VALUES (1969,Medicine,Alfred D. Hershey);427 INSERT INTO nobel VALUES (1969,Medicine,Salvador E. Luria);428 INSERT INTO nobel VALUES (1970,Medicine,Julius Axelrod);429 INSERT INTO nobel VALUES (1970,Medicine,Sir Bernard Katz);430 INSERT INTO nobel VALUES (1970,Medicine,Ulf von Euler);431 INSERT INTO nobel VALUES (1971,Medicine,Earl W. Sutherland, Jr.);432 INSERT INTO nobel VALUES (1972,Medicine,Gerald M. Edelman);433 INSERT INTO nobel VALUES (1972,Medicine,Rodney R. Porter);434 INSERT INTO nobel VALUES (1973,Medicine,Konrad Lorenz);435 INSERT INTO nobel VALUES (1973,Medicine,Nikolaas Tinbergen);436 INSERT INTO nobel VALUES (1973,Medicine,Karl von Frisch);437 INSERT INTO nobel VALUES (1974,Medicine,Albert Claude);438 INSERT INTO nobel VALUES (1974,Medicine,Christian de Duve);439 INSERT INTO nobel VALUES (1974,Medicine,George E. Palade);440 INSERT INTO nobel VALUES (1975,Medicine,David Baltimore);441 INSERT INTO nobel VALUES (1975,Medicine,Renato Dulbecco);442 INSERT INTO nobel VALUES (1975,Medicine,Howard M. Temin);443 INSERT INTO nobel VALUES (1976,Medicine,Baruch S. Blumberg);444 INSERT INTO nobel VALUES (1976,Medicine,D. Carleton Gajdusek);445 INSERT INTO nobel VALUES (1977,Medicine,Roger Guillemin);446 INSERT INTO nobel VALUES (1977,Medicine,Andrew V. Schally);447 INSERT INTO nobel VALUES (1977,Medicine,Rosalyn Yalow);448 INSERT INTO nobel VALUES (1978,Medicine,Werner Arber);449 INSERT INTO nobel VALUES (1978,Medicine,Daniel Nathans);450 INSERT INTO nobel VALUES (1978,Medicine,Hamilton O. Smith);451 INSERT INTO nobel VALUES (1979,Medicine,Allan M. Cormack);452 INSERT INTO nobel VALUES (1979,Medicine,Godfrey N. Hounsfield);453 INSERT INTO nobel VALUES (1980,Medicine,Baruj Benacerraf);454 INSERT INTO nobel VALUES (1980,Medicine,Jean Dausset);455 INSERT INTO nobel VALUES (1980,Medicine,George D. Snell);456 INSERT INTO nobel VALUES (1981,Medicine,David H. Hubel);457 INSERT INTO nobel VALUES (1981,Medicine,Roger W. Sperry);458 INSERT INTO nobel VALUES (1981,Medicine,Torsten N. Wiesel);459 INSERT INTO nobel VALUES (1982,Medicine,Sune K. Bergstream);460 INSERT INTO nobel VALUES (1982,Medicine,Bengt I. Samuelsson);461 INSERT INTO nobel VALUES (1982,Medicine,John R. Vane);462 INSERT INTO nobel VALUES (1983,Medicine,Barbara McClintock);463 INSERT INTO nobel VALUES (1984,Medicine,Niels K. Jerne);464 INSERT INTO nobel VALUES (1984,Medicine,Georges J.F. Kter);465 INSERT INTO nobel VALUES (1984,Medicine,Car Milstein);466 INSERT INTO nobel VALUES (1985,Medicine,Michael S. Brown);467 INSERT INTO nobel VALUES (1985,Medicine,Joseph L. Goldstein);468 INSERT INTO nobel VALUES (1986,Medicine,Stanley Cohen);469 -- tabnobel, 451, 50470 INSERT INTO nobel VALUES (1986,Medicine,Rita Levi-Montalcini);471 INSERT INTO nobel VALUES (1987,Medicine,Susumu Tonegawa);472 INSERT INTO nobel VALUES (1988,Medicine,Sir James W. Black);473 INSERT INTO nobel VALUES (1988,Medicine,Gertrude B. Elion);474 INSERT INTO nobel VALUES (1988,Medicine,George H. Hitchings);475 INSERT INTO nobel VALUES (1989,Medicine,J. Michael Bishop);476 INSERT INTO nobel VALUES (1989,Medicine,Harold E. Varmus);477 INSERT INTO nobel VALUES (1990,Medicine,Joseph E. Murray);478 INSERT INTO nobel VALUES (1990,Medicine,E. Donl Thomas);479 INSERT INTO nobel VALUES (1991,Medicine,Erwin Neher);480 INSERT INTO nobel VALUES (1991,Medicine,Bert Sakmann);481 INSERT INTO nobel VALUES (1992,Medicine,Edmond H. Fischer);482 INSERT INTO nobel VALUES (1992,Medicine,Edwin G. Krebs);483 INSERT INTO nobel VALUES (1993,Medicine,Richard J. Roberts);484 INSERT INTO nobel VALUES (1993,Medicine,Phillip A. Sharp);485 INSERT INTO nobel VALUES (1994,Medicine,Alfred G. Gilman);486 INSERT INTO nobel VALUES (1994,Medicine,Martin Rodbell);487 INSERT INTO nobel VALUES (1995,Medicine,Edward B. Lewis);488 INSERT INTO nobel VALUES (1995,Medicine,Christiane N??n-Volhard);489 INSERT INTO nobel VALUES (1995,Medicine,Eric F. Wieschaus);490 INSERT INTO nobel VALUES (1996,Medicine,Peter C. Doherty);491 INSERT INTO nobel VALUES (1996,Medicine,Rolf M. Zinkernagel);492 INSERT INTO nobel VALUES (1997,Medicine,Stanley B. Prusiner);493 INSERT INTO nobel VALUES (1998,Medicine,Robert F. Furchgott);494 INSERT INTO nobel VALUES (1998,Medicine,uis J. Ignarro);495 INSERT INTO nobel VALUES (1998,Medicine,Ferid Murad);496 INSERT INTO nobel VALUES (1999,Medicine,GaeBlobel);497 INSERT INTO nobel VALUES (2000,Medicine,Arvid Carlsson);498 INSERT INTO nobel VALUES (2000,Medicine,Paul Greengard);499 INSERT INTO nobel VALUES (2000,Medicine,Eric R. Kandel);500 INSERT INTO nobel VALUES (2001,Medicine,Leland H. Hartwell);501 INSERT INTO nobel VALUES (2001,Medicine,Tim Hunt);502 INSERT INTO nobel VALUES (2001,Medicine,Sir Paul Nurse);503 INSERT INTO nobel VALUES (2002,Medicine,Sydney Brenner);504 INSERT INTO nobel VALUES (2002,Medicine,H. Robert Horvitz);505 INSERT INTO nobel VALUES (2002,Medicine,John E. Sulston);506 INSERT INTO nobel VALUES (2003,Medicine,Paul C. Lauterbur);507 INSERT INTO nobel VALUES (2003,Medicine,Sir Peter Mansfield);508 INSERT INTO nobel VALUES (2004,Medicine,Richard Axel);509 INSERT INTO nobel VALUES (2004,Medicine,Linda B. Buck);510 INSERT INTO nobel VALUES (2005,Medicine,Barry J. Marshall);511 INSERT INTO nobel VALUES (2005,Medicine,J. Robin Warren);512 INSERT INTO nobel VALUES (1901,Peace,Henry Dunant);513 INSERT INTO nobel VALUES (1901,Peace,Fraeric Passy);514 INSERT INTO nobel VALUES (1902,Peace,Pie Ducommun);515 INSERT INTO nobel VALUES (1902,Peace,Albert Gobat);516 INSERT INTO nobel VALUES (1903,Peace,Randal Cremer);517 INSERT INTO nobel VALUES (1904,Peace,Institute of International Law);518 INSERT INTO nobel VALUES (1905,Peace,Bertha von Suttner);519 INSERT INTO nobel VALUES (1906,Peace,Theodore Roosevelt);520 -- tabnobel, 501, 50521 INSERT INTO nobel VALUES (1907,Peace,Ernesto Teodoro Moneta);522 INSERT INTO nobel VALUES (1907,Peace,Louis Renault);523 INSERT INTO nobel VALUES (1908,Peace,Klas Pontus Arnoldson);524 INSERT INTO nobel VALUES (1908,Peace,Fredrik Bajer);525 INSERT INTO nobel VALUES (1909,Peace,Auguste Beernaert);526 INSERT INTO nobel VALUES (1909,Peace,Paul Henri d‘‘Estournelles de Constant);527 INSERT INTO nobel VALUES (1910,Peace,Permanent Internationaeace Bureau);528 INSERT INTO nobel VALUES (1911,Peace,Tobias Asser);529 INSERT INTO nobel VALUES (1911,Peace,Alfred Fried);530 INSERT INTO nobel VALUES (1912,Peace,Elihu Root);531 INSERT INTO nobel VALUES (1913,Peace,Henri La Fontaine);532 INSERT INTO nobel VALUES (1917,Peace,International Committee of the Red Cross);533 INSERT INTO nobel VALUES (1919,Peace,Woodrow Wilson);534 INSERT INTO nobel VALUES (1920,Peace,Li Bourgeois);535 INSERT INTO nobel VALUES (1921,Peace,Hjalmar Branting);536 INSERT INTO nobel VALUES (1921,Peace,Christian Lange);537 INSERT INTO nobel VALUES (1922,Peace,Fridtjof Nansen);538 INSERT INTO nobel VALUES (1925,Peace,Sir Austen Chamberlain);539 INSERT INTO nobel VALUES (1925,Peace,Charles G. Dawes);540 INSERT INTO nobel VALUES (1926,Peace,Aristide Briand);541 INSERT INTO nobel VALUES (1926,Peace,Gustav Stresemann);542 INSERT INTO nobel VALUES (1927,Peace,Ferdinand Buisson);543 INSERT INTO nobel VALUES (1927,Peace,Ludwig Quidde);544 INSERT INTO nobel VALUES (1929,Peace,Frank B. Kellogg);545 INSERT INTO nobel VALUES (1930,Peace,Nathan Sablom);546 INSERT INTO nobel VALUES (1931,Peace,Jane Addams);547 INSERT INTO nobel VALUES (1931,Peace,Nicholas Murray Butler);548 INSERT INTO nobel VALUES (1933,Peace,Sir Norman Angell);549 INSERT INTO nobel VALUES (1934,Peace,Arthur Henderson);550 INSERT INTO nobel VALUES (1935,Peace,Carl von Ossietzky);551 INSERT INTO nobel VALUES (1936,Peace,Carlos Saavedra Lamas);552 INSERT INTO nobel VALUES (1937,Peace,Robert Cecil);553 INSERT INTO nobel VALUES (1938,Peace,Nansen International Office for Refugees);554 INSERT INTO nobel VALUES (1944,Peace,International Committee of the Red Cross);555 INSERT INTO nobel VALUES (1945,Peace,Cordell Hull);556 INSERT INTO nobel VALUES (1946,Peace,Emily Greene Balch);557 INSERT INTO nobel VALUES (1946,Peace,John R. Mott);558 INSERT INTO nobel VALUES (1947,Peace,Friends Service Council);559 INSERT INTO nobel VALUES (1947,Peace,American Friends Service Committee);560 INSERT INTO nobel VALUES (1949,Peace,Lord Boyd Orr);561 INSERT INTO nobel VALUES (1950,Peace,Ralph Bunche);562 INSERT INTO nobel VALUES (1951,Peace,Li Jouhaux);563 INSERT INTO nobel VALUES (1952,Peace,Albert Schweitzer);564 INSERT INTO nobel VALUES (1953,Peace,George C. Marshall);565 INSERT INTO nobel VALUES (1954,Peace,Office of the United Nations High Commissioner for Refugees);566 INSERT INTO nobel VALUES (1957,Peace,Lester Bowles Pearson);567 INSERT INTO nobel VALUES (1958,Peace,Georges Pire);568 INSERT INTO nobel VALUES (1959,Peace,Philip Noel-Baker);569 INSERT INTO nobel VALUES (1960,Peace,Albert Lutuli);570 INSERT INTO nobel VALUES (1961,Peace,Dag Hammarskjtld);571 -- tabnobel, 551, 50572 INSERT INTO nobel VALUES (1962,Peace,Linus Pauling);573 INSERT INTO nobel VALUES (1963,Peace,International Committee of the Red Cross);574 INSERT INTO nobel VALUES (1963,Peace,League of Red Cross Societies);575 INSERT INTO nobel VALUES (1964,Peace,Martin Luther King);576 INSERT INTO nobel VALUES (1965,Peace,United Nations Children‘‘s Fund);577 INSERT INTO nobel VALUES (1968,Peace,Renrassin);578 INSERT INTO nobel VALUES (1969,Peace,International Labour Organization);579 INSERT INTO nobel VALUES (1970,Peace,Norman Borlaug);580 INSERT INTO nobel VALUES (1971,Peace,Willy Brandt);581 INSERT INTO nobel VALUES (1973,Peace,Le Duc Tho);582 INSERT INTO nobel VALUES (1973,Peace,Henry Kissinger);583 INSERT INTO nobel VALUES (1974,Peace,SetMacBride);584 INSERT INTO nobel VALUES (1974,Peace,Eisaku Sato);585 INSERT INTO nobel VALUES (1975,Peace,Andrei Sakharov);586 INSERT INTO nobel VALUES (1976,Peace,Mairead Corrigan);587 INSERT INTO nobel VALUES (1976,Peace,Betty Williams);588 INSERT INTO nobel VALUES (1977,Peace,Amnesty International);589 INSERT INTO nobel VALUES (1978,Peace,Anwar al-Sadat);590 INSERT INTO nobel VALUES (1978,Peace,Menachem Begin);591 INSERT INTO nobel VALUES (1979,Peace,Mother Teresa);592 INSERT INTO nobel VALUES (1980,Peace,Adolfo Pize Esquivel);593 INSERT INTO nobel VALUES (1981,Peace,Office of the United Nations High Commissioner for Refugees);594 INSERT INTO nobel VALUES (1982,Peace,Alfonso Garce-Robles);595 INSERT INTO nobel VALUES (1982,Peace,Alva Myrdal);596 INSERT INTO nobel VALUES (1983,Peace,Lech Walesa);597 INSERT INTO nobel VALUES (1984,Peace,Desmond Tutu);598 INSERT INTO nobel VALUES (1985,Peace,International Physicians for the Prevention of Nuclear War);599 INSERT INTO nobel VALUES (1986,Peace,Elie Wiesel);600 INSERT INTO nobel VALUES (1987,Peace,Oscar Arias S??hez);601 INSERT INTO nobel VALUES (1988,Peace,United Nations Peacekeeping Forces);602 INSERT INTO nobel VALUES (1989,Peace,The 14th Dalai Lama);603 INSERT INTO nobel VALUES (1990,Peace,Mikhail Gorbachev);604 INSERT INTO nobel VALUES (1991,Peace,Aung San Suu Kyi);605 INSERT INTO nobel VALUES (1992,Peace,Rigoberta Mench?o);606 INSERT INTO nobel VALUES (1993,Peace,F.W. de Klerk);607 INSERT INTO nobel VALUES (1993,Peace,Nelson Mandela);608 INSERT INTO nobel VALUES (1994,Peace,Yasser Arafat);609 INSERT INTO nobel VALUES (1994,Peace,Shimon Peres);610 INSERT INTO nobel VALUES (1994,Peace,Yitzhak Rabin);611 INSERT INTO nobel VALUES (1995,Peace,Pugwash Conferences on Science and World Affairs);612 INSERT INTO nobel VALUES (1995,Peace,Joseph Rotblat);613 INSERT INTO nobel VALUES (1996,Peace,Carlos Filipe Ximenes Belo);614 INSERT INTO nobel VALUES (1996,Peace,Jos tamos-Horta);615 INSERT INTO nobel VALUES (1997,Peace,International Campaign to Ban Landmines);616 INSERT INTO nobel VALUES (1997,Peace,Jody Williams);617 INSERT INTO nobel VALUES (1998,Peace,John Hume);618 INSERT INTO nobel VALUES (1998,Peace,David Trimble);619 INSERT INTO nobel VALUES (1999,Peace,Macins Sans Fronties);620 INSERT INTO nobel VALUES (2000,Peace,Kim Dae-jung);621 INSERT INTO nobel VALUES (2001,Peace,United Nations);622 -- tabnobel, 601, 50623 INSERT INTO nobel VALUES (2001,Peace,Kofi Annan);624 INSERT INTO nobel VALUES (2002,Peace,Jimmy Carter);625 INSERT INTO nobel VALUES (2003,Peace,Shirin Ebadi);626 INSERT INTO nobel VALUES (2004,Peace,Wangari Maathai);627 INSERT INTO nobel VALUES (2005,Peace,International Atomic Energy Agency);628 INSERT INTO nobel VALUES (2005,Peace,Mohamed ElBaradei);629 INSERT INTO nobel VALUES (1901,Physics,Wilhelm Conrad Raen);630 INSERT INTO nobel VALUES (1902,Physics,Hendrik A. Lorentz);631 INSERT INTO nobel VALUES (1902,Physics,Pieter Zeeman);632 INSERT INTO nobel VALUES (1903,Physics,Henri Becquerel);633 INSERT INTO nobel VALUES (1903,Physics,Pierre Curie);634 INSERT INTO nobel VALUES (1903,Physics,Marie Curie);635 INSERT INTO nobel VALUES (1904,Physics,Lord Rayleigh);636 INSERT INTO nobel VALUES (1905,Physics,Philipp Lenard);637 INSERT INTO nobel VALUES (1906,Physics,J.J. Thomson);638 INSERT INTO nobel VALUES (1907,Physics,Albert A. Michelson);639 INSERT INTO nobel VALUES (1908,Physics,Gabriel Lippmann);640 INSERT INTO nobel VALUES (1909,Physics,Ferdinand Braun);641 INSERT INTO nobel VALUES (1909,Physics,Guglielmo Marconi);642 INSERT INTO nobel VALUES (1910,Physics,Johannes Diderik van der Waals);643 INSERT INTO nobel VALUES (1911,Physics,Wilhelm Wien);644 INSERT INTO nobel VALUES (1912,Physics,Gustaf Dall);645 INSERT INTO nobel VALUES (1914,Physics,Max von Laue);646 INSERT INTO nobel VALUES (1915,Physics,William Bragg);647 INSERT INTO nobel VALUES (1915,Physics,Lawrence Bragg);648 INSERT INTO nobel VALUES (1917,Physics,Charles Glover Barkla);649 INSERT INTO nobel VALUES (1918,Physics,Max Planck);650 INSERT INTO nobel VALUES (1919,Physics,Johannes Stark);651 INSERT INTO nobel VALUES (1920,Physics,Charles Edouard Guillaume);652 INSERT INTO nobel VALUES (1921,Physics,Albert Einstein);653 INSERT INTO nobel VALUES (1922,Physics,Niels Bohr);654 INSERT INTO nobel VALUES (1923,Physics,Robert A. Millikan);655 INSERT INTO nobel VALUES (1924,Physics,Manne Siegbahn);656 INSERT INTO nobel VALUES (1925,Physics,James Franck);657 INSERT INTO nobel VALUES (1925,Physics,Gustav Hertz);658 INSERT INTO nobel VALUES (1926,Physics,Jean Baptiste Perrin);659 INSERT INTO nobel VALUES (1927,Physics,Arthur H. Compton);660 INSERT INTO nobel VALUES (1927,Physics,C.T.R. Wilson);661 INSERT INTO nobel VALUES (1928,Physics,Owen Willans Richardson);662 INSERT INTO nobel VALUES (1929,Physics,Louis de Broglie);663 INSERT INTO nobel VALUES (1930,Physics,Venkata Raman);664 INSERT INTO nobel VALUES (1932,Physics,Werner Heisenberg);665 INSERT INTO nobel VALUES (1933,Physics,Paul A.M. Dirac);666 INSERT INTO nobel VALUES (1933,Physics,Erwin Schr??ger);667 INSERT INTO nobel VALUES (1935,Physics,James Chadwick);668 INSERT INTO nobel VALUES (1936,Physics,Carl D. Anderson);669 INSERT INTO nobel VALUES (1936,Physics,Victor F. Hess);670 INSERT INTO nobel VALUES (1937,Physics,Clinton Davisson);671 INSERT INTO nobel VALUES (1937,Physics,George Paget Thomson);672 INSERT INTO nobel VALUES (1938,Physics,Enrico Fermi);673 -- tabnobel, 651, 50674 INSERT INTO nobel VALUES (1939,Physics,Ernest Lawrence);675 INSERT INTO nobel VALUES (1943,Physics,Otto Stern);676 INSERT INTO nobel VALUES (1944,Physics,Isidor Isaac Rabi);677 INSERT INTO nobel VALUES (1945,Physics,Wolfgang Pauli);678 INSERT INTO nobel VALUES (1946,Physics,Percy W. Bridgman);679 INSERT INTO nobel VALUES (1947,Physics,Edward V. Appleton);680 INSERT INTO nobel VALUES (1948,Physics,Patrick M.S. Blackett);681 INSERT INTO nobel VALUES (1949,Physics,Hideki Yukawa);682 INSERT INTO nobel VALUES (1950,Physics,Cecil Powell);683 INSERT INTO nobel VALUES (1951,Physics,John Cockcroft);684 INSERT INTO nobel VALUES (1951,Physics,Ernest T.S. Walton);685 INSERT INTO nobel VALUES (1952,Physics,Felix Bloch);686 INSERT INTO nobel VALUES (1952,Physics,E. M. Purcell);687 INSERT INTO nobel VALUES (1953,Physics,Frits Zernike);688 INSERT INTO nobel VALUES (1954,Physics,Max Born);689 INSERT INTO nobel VALUES (1954,Physics,Walther Bothe);690 INSERT INTO nobel VALUES (1955,Physics,Polykarp Kusch);691 INSERT INTO nobel VALUES (1955,Physics,Willis E. Lamb);692 INSERT INTO nobel VALUES (1956,Physics,John Bardeen);693 INSERT INTO nobel VALUES (1956,Physics,Walter H. Brattain);694 INSERT INTO nobel VALUES (1956,Physics,William B. Shockley);695 INSERT INTO nobel VALUES (1957,Physics,Tsung-Dao Lee);696 INSERT INTO nobel VALUES (1957,Physics,Chen Ning Yang);697 INSERT INTO nobel VALUES (1958,Physics,Pavel A. Cherenkov);698 INSERT INTO nobel VALUES (1958,Physics,Ili ja M. Frank);699 INSERT INTO nobel VALUES (1958,Physics,Igor Y. Tamm);700 INSERT INTO nobel VALUES (1959,Physics,Owen Chamberlain);701 INSERT INTO nobel VALUES (1959,Physics,Emilio Segrte);702 INSERT INTO nobel VALUES (1960,Physics,Donald A. Glaser);703 INSERT INTO nobel VALUES (1961,Physics,Robert Hofstadter);704 INSERT INTO nobel VALUES (1961,Physics,Rudolf Meauer);705 INSERT INTO nobel VALUES (1962,Physics,Lev Landau);706 INSERT INTO nobel VALUES (1963,Physics,Maria Goeppert-Mayer);707 INSERT INTO nobel VALUES (1963,Physics,J. Hans D. Jensen);708 INSERT INTO nobel VALUES (1963,Physics,Eugene Wigner);709 INSERT INTO nobel VALUES (1964,Physics,Nicolay G. Basov);710 INSERT INTO nobel VALUES (1964,Physics,Aleksandr M. Prokhorov);711 INSERT INTO nobel VALUES (1964,Physics,Charles H. Townes);712 INSERT INTO nobel VALUES (1965,Physics,Richard P. Feynman);713 INSERT INTO nobel VALUES (1965,Physics,Julian Schwinger);714 INSERT INTO nobel VALUES (1965,Physics,Sin-Itiro Tomonaga);715 INSERT INTO nobel VALUES (1966,Physics,Alfred Kastler);716 INSERT INTO nobel VALUES (1967,Physics,Hans Bethe);717 INSERT INTO nobel VALUES (1968,Physics,Luis Alvarez);718 INSERT INTO nobel VALUES (1969,Physics,Murray Gell-Mann);719 INSERT INTO nobel VALUES (1970,Physics,Hannes Alfvin);720 INSERT INTO nobel VALUES (1970,Physics,Louis Nice);721 INSERT INTO nobel VALUES (1971,Physics,Dennis Gabor);722 INSERT INTO nobel VALUES (1972,Physics,John Bardeen);723 INSERT INTO nobel VALUES (1972,Physics,Leon N. Cooper);724 -- tabnobel01, 50725 INSERT INTO nobel VALUES (1972,Physics,Robert Schrieffer);726 INSERT INTO nobel VALUES (1973,Physics,Leo Esaki);727 INSERT INTO nobel VALUES (1973,Physics,Ivar Giaever);728 INSERT INTO nobel VALUES (1973,Physics,Brian D. Josephson);729 INSERT INTO nobel VALUES (1974,Physics,Antony Hewish);730 INSERT INTO nobel VALUES (1974,Physics,Martin Ryle);731 INSERT INTO nobel VALUES (1975,Physics,Aage N. Bohr);732 INSERT INTO nobel VALUES (1975,Physics,Ben R. Mottelson);733 INSERT INTO nobel VALUES (1975,Physics,James Rainwater);734 INSERT INTO nobel VALUES (1976,Physics,Burton Richter);735 INSERT INTO nobel VALUES (1976,Physics,Samuel C.C. Ting);736 INSERT INTO nobel VALUES (1977,Physics,Philip W. Anderson);737 INSERT INTO nobel VALUES (1977,Physics,Sir Nevill F. Mott);738 INSERT INTO nobel VALUES (1977,Physics,John H. van Vleck);739 INSERT INTO nobel VALUES (1978,Physics,Pyotr Kapitsa);740 INSERT INTO nobel VALUES (1978,Physics,Arno Penzias);741 INSERT INTO nobel VALUES (1978,Physics,Robert Woodrow Wilson);742 INSERT INTO nobel VALUES (1979,Physics,Sheldon Glashow);743 INSERT INTO nobel VALUES (1979,Physics,Abdus Salam);744 INSERT INTO nobel VALUES (1979,Physics,Steven Weinberg);745 INSERT INTO nobel VALUES (1980,Physics,James Cronin);746 INSERT INTO nobel VALUES (1980,Physics,Val Fitch);747 INSERT INTO nobel VALUES (1981,Physics,Nicolaas Bloembergen);748 INSERT INTO nobel VALUES (1981,Physics,Arthur L. Schawlow);749 INSERT INTO nobel VALUES (1981,Physics,Kai M. Siegbahn);750 INSERT INTO nobel VALUES (1982,Physics,Kenneth G. Wilson);751 INSERT INTO nobel VALUES (1983,Physics,Subramanyan Chandrasekhar);752 INSERT INTO nobel VALUES (1983,Physics,William A. Fowler);753 INSERT INTO nobel VALUES (1984,Physics,Carlo Rubbia);754 INSERT INTO nobel VALUES (1984,Physics,Simon van der Meer);755 INSERT INTO nobel VALUES (1985,Physics,Klaus von Klitzing);756 INSERT INTO nobel VALUES (1986,Physics,Gerd Binnig);757 INSERT INTO nobel VALUES (1986,Physics,HeinriRohrer);758 INSERT INTO nobel VALUES (1986,Physics,Ernst Ruska);759 INSERT INTO nobel VALUES (1987,Physics,J. Georg Bednorz);760 INSERT INTO nobel VALUES (1987,Physics,K. Alex Mikeller);761 INSERT INTO nobel VALUES (1988,Physics,Leon M. Lederman);762 INSERT INTO nobel VALUES (1988,Physics,Melvin Schwartz);763 INSERT INTO nobel VALUES (1988,Physics,Jack Steinberger);764 INSERT INTO nobel VALUES (1989,Physics,Hans G. Dehmelt);765 INSERT INTO nobel VALUES (1989,Physics,Wolfgang Paul);766 INSERT INTO nobel VALUES (1989,Physics,Norman F. Ramsey);767 INSERT INTO nobel VALUES (1990,Physics,Jerome I. Friedman);768 INSERT INTO nobel VALUES (1990,Physics,Henry W. Kendall);769 INSERT INTO nobel VALUES (1990,Physics,Richard E. Taylor);770 INSERT INTO nobel VALUES (1991,Physics,Pierre-Gilles de Gennes);771 INSERT INTO nobel VALUES (1992,Physics,Georges Charpak);772 INSERT INTO nobel VALUES (1993,Physics,Russell A. Hulse);773 INSERT INTO nobel VALUES (1993,Physics,Joseph H. Taylor Jr.);774 INSERT INTO nobel VALUES (1994,Physics,Bertram N. Brockhouse);775 -- tabnobel, 751, 50776 INSERT INTO nobel VALUES (1994,Physics,Clifford G. Shull);777 INSERT INTO nobel VALUES (1995,Physics,Martin L. Perl);778 INSERT INTO nobel VALUES (1995,Physics,Frederick Reines);779 INSERT INTO nobel VALUES (1996,Physics,David M. Lee);780 INSERT INTO nobel VALUES (1996,Physics,Douglas D. Osheroff);781 INSERT INTO nobel VALUES (1996,Physics,Robert C. Richardson);782 INSERT INTO nobel VALUES (1997,Physics,Steven Chu);783 INSERT INTO nobel VALUES (1997,Physics,Claude Cohen-Tannoudji);784 INSERT INTO nobel VALUES (1997,Physics,William D. Phillips);785 INSERT INTO nobel VALUES (1998,Physics,Robert B. Laughlin);786 INSERT INTO nobel VALUES (1998,Physics,Horst L. Steer);787 INSERT INTO nobel VALUES (1998,Physics,Daniel C. Tsui);788 INSERT INTO nobel VALUES (1999,Physics,Gerardus ‘‘t Hooft);789 INSERT INTO nobel VALUES (1999,Physics,Martinus J.G. Veltman);790 INSERT INTO nobel VALUES (2000,Physics,res I. Alferov);791 INSERT INTO nobel VALUES (2000,Physics,Jack S. Kilby);792 INSERT INTO nobel VALUES (2000,Physics,Herbert Kroemer);793 INSERT INTO nobel VALUES (2001,Physics,Eric A. Cornell);794 INSERT INTO nobel VALUES (2001,Physics,Wolfgang Ketterle);795 INSERT INTO nobel VALUES (2001,Physics,Carl E. Wieman);796 INSERT INTO nobel VALUES (2002,Physics,Raymond Davis Jr.);797 INSERT INTO nobel VALUES (2002,Physics,Riccardo Giacconi);798 INSERT INTO nobel VALUES (2002,Physics,Masatoshi Koshiba);799 INSERT INTO nobel VALUES (2003,Physics,Alexei A. Abrikosov);800 INSERT INTO nobel VALUES (2003,Physics,Vitaly L. Ginzburg);801 INSERT INTO nobel VALUES (2003,Physics,Anthony J. Leggett);802 INSERT INTO nobel VALUES (2004,Physics,David J. Gross);803 INSERT INTO nobel VALUES (2004,Physics,H. David Politzer);804 INSERT INTO nobel VALUES (2004,Physics,Frank Wilczek);805 INSERT INTO nobel VALUES (2005,Physics,Roy J. Glauber);806 INSERT INTO nobel VALUES (2005,Physics,John L. Hall);807 INSERT INTO nobel VALUES (2005,Physics,Theodor W. Hich);808 809 810 -- 给出诺贝尔奖获奖总人数811 SELECT COUNT(DISTINCT winner) FROM nobel;812 813 -- 给出诺贝尔物理奖获奖次数814 SELECT COUNT(*) FROM nobel WHERE SUBJECT=Physics815 816 -- 显示每个奖项获奖总次数817 SELECT SUBJECT,COUNT(SUBJECT) FROM nobel GROUP BY SUBJECT;818 819 820 -- 显示每个奖项第一次获得该奖的年份821 SELECT SUBJECT,MIN(yr) FROM nobel GROUP BY SUBJECT;822 823 -- 显示每个奖项在2000年获奖的人数824 SELECT SUBJECT,COUNT(winner) FROM nobel WHERE yr=2000 GROUP BY SUBJECT;825 826 -- 显示每个奖项不同获奖者人数827 SELECT SUBJECT,COUNT(DISTINCT winner) FROM nobel GROUP BY SUBJECT;828 829 -- 显示每个奖项有多少年获奖830 SELECT SUBJECT,COUNT(DISTINCT yr) FROM nobel GROUP BY SUBJECT;831 832 -- 显示当年有三个物理奖的年份833 SELECT yr FROM nobel WHERE SUBJECT=Physics GROUP BY yr834  HAVING COUNT(*)=3835 836 -- 显示得奖超过一次的获奖者837 SELECT winner FROM nobel GROUP BY winner HAVING COUNT(*)>1838 839 -- 显示得到多个奖项的获奖者840 SELECT winner,COUNT(DISTINCT SUBJECT) s  FROM nobel GROUP BY winner 841 HAVING s>1;842 843 -- 显示2000年及以后,有三个人获得同一奖项的年份及奖项844 SELECT  yr,SUBJECT FROM nobel WHERE yr>=2000 GROUP BY yr,SUBJECT845 HAVING  COUNT(DISTINCT winner)=3

 

2016.9.26小程序---数据库练习2