Frequently Accessed Course

select count (*) as "COUNT", aa.COURSE_PK1, CM.COURSE_NAME, CM.COURSE_ID
from BB_BB60_STATS.ACTIVITY_ACCUMULATOR aa, BB_BB60_STATS.COURSE_MAIN cm
WHERE
CM.PK1 = AA.COURSE_PK1 AND
AA.COURSE_PK1 IS NOT NULL AND
AA.COURSE_PK1 <> 1
GROUP BY
AA.COURSE_PK1,
CM.COURSE_NAME,
CM.COURSE_ID
ORDER BY count DESC;