Files
yanxuan/数据库/q_target_codes.sql

4 lines
133 B
SQL

SELECT 专业代码, COUNT(*) AS n, COUNT(DISTINCT 院校) AS sch
FROM src_target_major
GROUP BY 专业代码 ORDER BY 专业代码;