Direction: Using the table below: nobel_win, Write the SQL statements of the following queries: Please include the output of each query. Table name: nobel_win YEAR SUBJECT WINNER COUNTRY CATEGORY Hannes Alfven Sweden Scientist Louis Neel France Scientist France Scientist 1978 Physics 1978 Physics 1978 Chemistry 1978 Physiology 1978 Physiology 1978 Literature Sweden Scientist Germany Scientist Russia 1978 Economics USA Linguist Economist Scientist USA Hungary Scientist Luis Federico Leloir Ulf von Euler Bernard Katz Aleksandr Solzhenitsyn Paul Samuelson Julius Axelrod Dennis Gabor Gerhard Herzberg Willy Brandt Pablo Neruda Simon Kuznets Anwar al-Sadat Menachen Begin Donald J. Cran Jean-Marie Lehn Germany Scientist Germany 1978 Physiology 1971 Physics 1971 Chemistry 1971 Peace 1971 Literature 1971 Economics 1978 Peace 1978 Peace Chancellor Chile Linguist Economist Russia President Egypt Israel Prime Minister Scientist USA France Scientist Scientist 1987 Chemistry 1987 Chemistry 1987 Physiology 1994 Economics 1994 Peace 1987 Physics 1987 Literature Susunu Tonegawa Reinhard Seiten Japan Germany Economist Yitzhak Rabin Israel Prime Minister Johannes Georg Bednorz Germany Scientist Russia Joseph Brodsky Robert Solow Linguist Economis 1987 Economics USA 1. Write a SQL query to know the winner of the 1971 prize for Literature. 2. Write a SQL query to display the year and subject that won 'Dennis Gabor' his prize. 3. Write a SQL query to give the name of the 'Physics' winners since the year 1950. 4. Write a SQL query to Show all the details (year, subject, winner, country) of the Chemistry prize winners between the year 1965 to 1975 inclusive. 5. Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

sql statement

Direction: Using the table below: nobel_win, Write the SQL statements of the
following queries: Please include the output of each query.
Table name: nobel_win
YEAR SUBJECT
WINNER
COUNTRY
CATEGORY
Hannes Alfven
Sweden
Scientist
Louis Neel
France
Scientist
France
Scientist
Sweden
Scientist
Luis Federico Leloir
Ulf von Euler
Bernard Katz
Aleksandr Solzhenitsyn
Germany
Scientist
Russia
Linguist
Economist
USA
1978 Physics
1978 Physics
1978 Chemistry
1978 Physiology
1978 Physiology
1978 Literature
1978 Economics
1978 Physiology
1971 Physics
1971 Chemistry
1971 Peace
1971 Literature
1971 Economics
1978 Peace
1978 Peace
USA
Scientist
Hungary
Scientist
Germany
Scientist
Germany
Chancellor
Paul Samuelson
Julius Axelrod
Dennis Gabor
Gerhard Herzberg
Willy Brandt
Pablo Neruda
Simon Kuznets
Anwar al-Sadat
Menachen Begin
Donald J. Cran
Jean-Marie Lehn
Chile
Linguist
Russia
Economist
President
Egypt
Israel
Prime Minister
USA
Scientist
France
Scientist
Japan
Scientist
1987 Chemistry
1987 Chemistry
1987 Physiology
1994 Economics
1994 Peace
1987 Physics
1987 Literature
Susunu Tonegawa
Reinhard Seiten
Germany
Economist
Yitzhak Rabin
Israel
Prime Minister
Germany
Scientist
Johannes Georg Bednorz
Joseph Brodsky
Russia
Linguist
Economis
1987 Economics
Robert Solow
USA
1. Write a SQL query to know the winner of the 1971 prize for Literature.
2. Write a SQL query to display the year and subject that won 'Dennis Gabor' his
prize.
3. Write a SQL query to give the name of the 'Physics' winners since the year 1950.
4. Write a SQL query to Show all the details (year, subject, winner, country) of the
Chemistry prize winners between the year 1965 to 1975 inclusive.
5. Write a SQL query to show all details of the Prime Ministerial winners after 1972 of
Menachem Begin and Yitzhak Rabin.
Transcribed Image Text:Direction: Using the table below: nobel_win, Write the SQL statements of the following queries: Please include the output of each query. Table name: nobel_win YEAR SUBJECT WINNER COUNTRY CATEGORY Hannes Alfven Sweden Scientist Louis Neel France Scientist France Scientist Sweden Scientist Luis Federico Leloir Ulf von Euler Bernard Katz Aleksandr Solzhenitsyn Germany Scientist Russia Linguist Economist USA 1978 Physics 1978 Physics 1978 Chemistry 1978 Physiology 1978 Physiology 1978 Literature 1978 Economics 1978 Physiology 1971 Physics 1971 Chemistry 1971 Peace 1971 Literature 1971 Economics 1978 Peace 1978 Peace USA Scientist Hungary Scientist Germany Scientist Germany Chancellor Paul Samuelson Julius Axelrod Dennis Gabor Gerhard Herzberg Willy Brandt Pablo Neruda Simon Kuznets Anwar al-Sadat Menachen Begin Donald J. Cran Jean-Marie Lehn Chile Linguist Russia Economist President Egypt Israel Prime Minister USA Scientist France Scientist Japan Scientist 1987 Chemistry 1987 Chemistry 1987 Physiology 1994 Economics 1994 Peace 1987 Physics 1987 Literature Susunu Tonegawa Reinhard Seiten Germany Economist Yitzhak Rabin Israel Prime Minister Germany Scientist Johannes Georg Bednorz Joseph Brodsky Russia Linguist Economis 1987 Economics Robert Solow USA 1. Write a SQL query to know the winner of the 1971 prize for Literature. 2. Write a SQL query to display the year and subject that won 'Dennis Gabor' his prize. 3. Write a SQL query to give the name of the 'Physics' winners since the year 1950. 4. Write a SQL query to Show all the details (year, subject, winner, country) of the Chemistry prize winners between the year 1965 to 1975 inclusive. 5. Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 10 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY