-- 按学校从这两张张表里统计出 总藏书册数, 总藏书总数, 和总藏书金额 SELECT COUNT(*) AS '总藏书册数', COUNT(DISTINCT a.B_No) AS '总藏书总数' , SUM(a.b_price) AS '总藏书金额', w.schoolName AS '学校' FROM B_Book a INNER JOIN B_Status b ON a.B_No=b.B_No INNER JOIN Web_School w ON w.schoolId=a.schoolId GROUP BY w.schoolName-- 再按价格细分SELECT COUNT(*) AS '总藏书册数', COUNT(DISTINCT a.B_No) AS '总藏书总数' , SUM(a.b_price) AS '总藏书金额', a.b_price AS '价格', w.schoolName AS '学校' FROM B_Book a INNER JOIN B_Status b ON a.B_No=b.B_No INNER JOIN Web_School w ON w.schoolId=a.schoolId GROUP BY w.schoolName, a.b_price
-- 按学校从这两张张表里统计出 总藏书册数, 总藏书总数, 和总藏书金额
SELECT COUNT(*) AS '总藏书册数', COUNT(DISTINCT a.B_No) AS '总藏书总数' , SUM(a.b_price) AS '总藏书金额', w.schoolName AS '学校'
FROM B_Book a INNER JOIN B_Status b ON a.B_No=b.B_No
INNER JOIN Web_School w ON w.schoolId=a.schoolId
GROUP BY w.schoolName-- 再按价格细分SELECT COUNT(*) AS '总藏书册数', COUNT(DISTINCT a.B_No) AS '总藏书总数' , SUM(a.b_price) AS '总藏书金额', a.b_price AS '价格', w.schoolName AS '学校'
FROM B_Book a INNER JOIN B_Status b ON a.B_No=b.B_No
INNER JOIN Web_School w ON w.schoolId=a.schoolId
GROUP BY w.schoolName, a.b_price