用于获取两种语言的sql查询

Question

我有学生表，列作为名称和语言。我有以下数据。

​

​

我想显示既懂java又懂c的学生姓名。我是sql新手，你能帮我写这个查询吗？

Answer 1

按名称分组，并仅选择具有两种语言的用户

select name
from student
where language in ('java','c')
group by name
having count(distinct language) = 2

Answer 2

SELECT l.name FROM students l
  JOIN students r
  ON l.name = r.name
  WHERE l.language = 'java'
    AND r.language = 'c';