SQL for WB export

Owned by Lisa Wilson
Last updated: Mar 17, 2007Version comment

SQL code used to generate export data for WB statistics:

select a.term_code, b.crn, subj_code, crse_numb, b.sec_numb, b.INST_KERBEROS_NAME,
sum(file_size_kbyte)/1000 as filesize
from page_metadata a, course_defaults b
where b.term_code = a.term_code
	  and b.crn = a.crn
group by a.term_code, b.crn, subj_code, crse_numb, sec_numb, b.INST_KERBEROS_NAME
having sum(file_size_kbyte) >= 1000 and sum(file_size_kbyte) < 5000
order by filesize desc