按课程年份划分的主要计数获取重复项(ORACLE PL/SQL)

我想你想要一个 join 和 group by :

SELECT e.pref_class_year as "CLASS"
       COUNT(d.id_number)
FROM entity e LEFT JOIN
     degrees d
     ON d.id_number = e.id_number AND
        '12' IN (d.major_code1, d.major_code2, d.major_code3)
WHERE e.record_type_code = 'AL' AND
      e.pref_class_year BETWEEN '1965' AND '2017'
GROUP BY e.pref_class_year
ORDER BY 1;

  SELECT  e.pref_class_year "CLASS"
    ,  nvl(COUNT (*), 0)
  from entity e
  left join degrees d on  d.id_number = e.id_number  AND 
                  (d.major_code1 = '12'
                       OR d.major_code2 = '12'
                       OR d.major_code3 = '12')
  WHERE e.record_type_code = 'AL'
    AND e.pref_class_year BETWEEN '1965' AND '2017'
  group by  e.pref_class_year
  ORDER BY 1