SQL面试题收录

1、用一条SQL语句 查询出每门课都大于80分的学生姓名

SELECT DISTINCT 
  NAME 
FROM
  t_score_tab 
WHERE NAME NOT IN 
  (SELECT DISTINCT 
    NAME 
  FROM
    t_score_tab 
  WHERE score <= 80)