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.
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...
Related questions
Question
sql statement
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 10 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY