What am I doing wrong with IN ? Please help.

Question

select teamname , country
from teams
order by teamname
where country IN ('spain', 'england', 'germany');

Answer 1

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.

Answer 2

select teamname ,country from teams
where country IN ('Spain','England','Germany')
ORDER BY teamname

Answer 3

Also, the WHERE clause has to come before the ORDER BY clause.

Answer 4

Thank you so much!

Answer 5

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)․

Answer 6

I see, I thought it was not case sensitive.

Answer 7

Leeah Jones

Should not be case sensitive but don't know which database Sololearn is using.

Answer 8

The question of case sensitivity in SQL depends on several factors:
https://learnsql.com/blog/sql-case-sensitive/

Answer 9

team database in SQL

Answer 10

Thank you

Answer 11

Leeah Jones

Just remove ORDER BY clause and you are done.

Also all countries name should start from Capital letter