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 Science Case Study You are the programmer at a recreation center. This recreation center has a database that tracks classes, enrollment, cancellation, revenues, and expenses for each program or class. The database also tracks customer demographics. What type of evaluation would you conduct on an annual basis using the available data?

Database Administration (SQL SERVER ARCHITECTURE ) What is the definition of “Always on Availability”?

Using a computer programming language to access and edit data in a relational database

Explain the different types of databases and their uses.

Describe the process of designing and developing a database.

Do you know how to enter user data into a database?

Please describe the KIS's various uses.

Differentiate between database management systems and file-oriented systems.

Differentiate between database management systems and file-oriented systems.