SQL for WB export
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