你可以用 group by 以及 having :

select uh.userid
from user_hobby uh join
     hobby h
     on h.hobbyid = uh.hobbyid
where h.hobby in ('drawing', 'singing')
group by uh.userid
having min(h.hobby) = max(h.hobby) and min(h.hobby) = 'drawing';

请注意，要获得 userid ，您不需要users表。

你可以 Group by 在userid和name上。这会将结果聚合到特定用户的单行中。
现在，我们可以使用 Having 与 Sum() 把箱子过滤掉。 Sum(hobby = 'drawing') 对于有绘画爱好的用户将是积极的。 Sum(hobby = 'singing') 对于没有唱歌作为爱好的用户来说将是零。
请尝试以下操作：

SELECT us.userid,
       us.name
FROM   hobbylist
       JOIN user_hobby AS uh
         ON hobbylist.hobbyid = uh.hobbyid
       JOIN users AS us
         ON us.userid = uh.userid
GROUP  BY us.userid,
          us.name
HAVING Sum(hobby = 'drawing')
       AND Sum(hobby = 'singing') = 0

尝试以下innerjoin：

select * from hobbylist, user_hobby, users where users.userid = user_hobby.userid and hobbylist.hobbyid = user_hobby.hobbyid and hobbylist.hobby = "drawing" and hobbylist.hobby <> "singing"