Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fix the following SQLS to generate what each question is asking for. Part 1 : Show all details of the presidential winners: Theodore Roosevelt Thomas
Fix the following SQLS to generate what each question is asking for.
Part :
Show all details of the presidential winners:
Theodore Roosevelt
Thomas Woodrow Wilson
Jimmy Carter
Barack Obama
SELECT FROM nobel
WHERE
AND subject IN Cookery
'Chemistry',
'Literature'
tableyrsubject,winnerpeace,Lon Victor Auguste Bourgeois
Show what the answer should be
tablesubject,winnerpeace,Theodore Rooseveltpeace,Thomas Woodrow Wilsonpeace,Jimmy Carterpeace,Barack Obama
Show the winners with first name John
SELECT winner
FROM nobel
WHERE yr
AND subject 'peace'
Memorial,
Show what the answer should be
tablewinnerJohn James Rickard MacleodJohn GalsworthyJohn Howard NorthropJohn Raleigh MottJohn Franklin EndersJohn Bardeen
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started