How would you write a query to select all teams that won either 2, 4, 6 or 8 games?

Question

Hello
How would you write a query to select all teams that won either 2, 4, 6 or 8 games?
please reply me. i am waiting for your reply.
Thanx

Answer 1

SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

Answer 2

select * from table name where filedname in(2,4,6,8)