Количество вопросов в банке курса:
SELECT
concat('<a target="_blank" href="%%WWWROOT%%/question/edit.php',CHAR(63),'courseid=',c.id,'">',c.fullname,'</a>') 'Курс',
Count(q.id) 'Вопросов'
FROM
{question} q
INNER JOIN {question_categories} qc ON qc.id = q.category AND q.qtype <> 'random' AND q.parent = 0
INNER JOIN {context} ctx ON ctx.id = qc.contextid
INNER JOIN {course} c ON c.id = ctx.instanceid AND ctx.contextlevel = 50
GROUP BY
c.id
ORDER BY
c.fullname
Количество вопросов в банках отдельных тестов
SELECT
CONCAT('<a target="_blank" href="%%WWWROOT%%/course/view.php',CHAR(63),'id=',c.id,'">',c.fullname,'</a>') 'Курс'
,CONCAT('<a target="_blank" href="%%WWWROOT%%/question/edit.php',CHAR(63),'cmid=',cm.id,'',CHAR(38),'category=',qc.id,'',CHAR(44),'',qc.contextid,'">',qc.name,'</a>') 'Категория'
,COUNT(q.id) 'Вопросов в банке теста'
FROM
{question} q
INNER JOIN {question_categories} qc ON q.category = qc.id AND q.qtype <> 'random' AND q.parent = '0'
INNER JOIN {context} ctx ON qc.contextid = ctx.id AND ctx.contextlevel = '70'
INNER JOIN {course_modules} cm ON ctx.instanceid = cm.id AND cm.module = (SELECT m.id FROM {modules} m WHERE m.name='quiz')
INNER JOIN {course} c ON c.id = cm.course
GROUP BY
qc.id
ORDER BY
c.fullname, qc.id