sql选出同时符合多个值记录

?

select * from testsqlWHERE HOBBY='basketball' and NAME in(      select NAME      from testsql      where HOBBY ='badminton')

?