SELECT SUM(給与) FROM 社員;
SELECT SUM(給与) FROM 社員 WHERE 部署ID = 5;
SELECT 部署ID, SUM(給与) FROM 社員 GROUP BY 部署ID;
SELECT 社員.部署ID, 部署名, SUM(給与) FROM 社員 INNER JOIN 部署 ON 部署.部署ID = 社員.部署ID GROUP BY 社員.部署ID;
SELECT 社員.部署ID, 部署名, SUM(給与) FROM 社員 INNER JOIN 部署 ON 部署.部署ID = 社員.部署ID GROUP BY 社員.部署ID ORDER BY SUM(給与) DESC;
SELECT 社員.部署ID, 部署名, SUM(給与) FROM 社員 INNER JOIN 部署 ON 部署.部署ID = 社員.部署ID GROUP BY 社員.部署ID HAVING SUM(給与) > 30000 ORDER BY SUM(給与) DESC;
SELECT * FROM 国;
SELECT * FROM 部署;
SELECT * FROM 扶養家族;
SELECT * FROM 社員;
SELECT * FROM 職務;
SELECT * FROM 拠点;
SELECT * FROM 地域;
