首页 > 代码库 > 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=‘Physics‘815 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
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。