SQL Query: Count Instructors per Department (University Schema)

• 日期: 2024-11-14
• 标签: 常规

SELECT d.dept_name, COUNT(i.ID) AS total_instructors
FROM department d
LEFT JOIN instructor i ON i.dept_name = d.dept_name
GROUP BY d.dept_name;

原文地址: https://www.cveoy.top/t/topic/mNS5 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录