What am I doing wrong with IN ? Please help.
select teamname , country from teams order by teamname where country IN ('spain', 'england', 'germany');
What was the task? Ensure the country names listed are *exactly* as shown in the task Description, letter case matters. 'Spain' not equal to 'spain' etc.
select teamname ,country from teams where country IN ('Spain','England','Germany') ORDER BY teamname
Also, the WHERE clause has to come before the ORDER BY clause.
Thank you so much!
Write a query to output the team names and the countries of all teams that have played in La Liga (Spain), Premier League (England) and Bundesliga (Germany)․
I see, I thought it was not case sensitive.
Leeah Jones Should not be case sensitive but don't know which database Sololearn is using.
The question of case sensitivity in SQL depends on several factors: https://learnsql.com/blog/sql-case-sensitive/
team database in SQL
Leeah Jones Just remove ORDER BY clause and you are done. Also all countries name should start from Capital letter