Reply to this forum with your response to the challenge set in this session...
I was wanting to know which courses used the Basic LTI mashup tool:
SELECT cm.id AS course_id, cm.name AS course_nameFROM cdm_lms.course cmJOIN cdm_lms.course_tool ct ON ct.course_id = cm.idJOIN cdm_lms.tool t ON t.id = ct.tool_idWHERE t.name LIKE 'Basic LTI%';
The results looked like the following:
The query shows the number of hits a certain tool has and the total duration time. It could be used for reporting to your institutions' managment.
There is room for improvement: via course_id the course_number from course table could be joined in. Via course_number and a join with course_catalog, subject_code can be retrieved.
That would all together give an overview of tool usage per subject.
select distinct tool_source_id, count (*) as hits, sum(duration_sum) as durationtime from course_tool_activitygroup by tool_source_idorder by 2 desc
Retrieving data ...