4 lines
133 B
SQL
4 lines
133 B
SQL
SELECT 专业代码, COUNT(*) AS n, COUNT(DISTINCT 院校) AS sch
|
|
FROM src_target_major
|
|
GROUP BY 专业代码 ORDER BY 专业代码;
|