write a SQL query to find the Nobel Prize winner(s) for the year 1970. Return year, subject and winner in SQL
SQL
🤖 Code Explanation
The code written in SQL SELECT year, subject, winner FROM nobel WHERE year = 1970; retrieves the year, subject, and winner from the Nobel table for the year 1970.
More problems solved in SQL
write a SQL query to find the Nobel Prize winner(s) for the year 1970. Return year, subject and winner
select all the users in the users table in MSSQL
Table departments, columns = [DepartmentId, DepartmentName]
Table students, columns = [DepartmentId, StudentId, StudentName]
msqql query for all students in the Computer Science Department
Table departments, columns = [DepartmentId, DepartmentName]
Table students, columns = [DepartmentId, StudentId, StudentName]
get all students in the Computer Science Department