SQL: Show all the details of the winners with first name Louis
SQL Basic Select Statement : Exercise-18 with Solution.
Write a SQL query to show all the details of the winners with first name Louis.
Sample table: nobel_win
SELECT * FROM nobel_win WHERE winner LIKE 'Louis%';
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.
Next: Write a SQL query to show all the winners in Physics for 1970 together with the winner of Economics for 1971.
What is the difficulty level of this exercise?