SELECT reader.DEPT_NAME AS 部门, YEAR(BKCHKOUT.oprt_date)
AS 年度,
(select count(dept_name) from reader where reader.position='研究生'
and (reader.dept_name='研究生部_00级'or reader.dept_name='_01级')
group by reader.position,reader.dept_name) as number,
sum(BKCHKOUT.db_key) AS 借书总数
FROM reader inner JOIN BKCHKOUT
ON BKCHKOUT.reader_bar = reader.READER_BAR
where reader.position='研究生'
GROUP BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)
ORDER BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)
我现在想就是用,借书总数去除以number然后显示为平均数,请问,我该如何修改这个语句
AS 年度,
(select count(dept_name) from reader where reader.position='研究生'
and (reader.dept_name='研究生部_00级'or reader.dept_name='_01级')
group by reader.position,reader.dept_name) as number,
sum(BKCHKOUT.db_key) AS 借书总数
FROM reader inner JOIN BKCHKOUT
ON BKCHKOUT.reader_bar = reader.READER_BAR
where reader.position='研究生'
GROUP BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)
ORDER BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)
我现在想就是用,借书总数去除以number然后显示为平均数,请问,我该如何修改这个语句
AS 年度,
(select count(dept_name) from reader where reader.position='研究生'
and (reader.dept_name='研究生部_00级'or reader.dept_name='_01级')
group by reader.position,reader.dept_name) as number/
sum(BKCHKOUT.db_key) AS 借书总数
FROM reader inner JOIN BKCHKOUT
ON BKCHKOUT.reader_bar = reader.READER_BAR
where reader.position='研究生'
GROUP BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)
ORDER BY reader.POSITION, reader.DEPT_NAME, YEAR(BKCHKOUT.oprt_date)