Sensei: Show specific course/lesson status report for a learner

sensei_learner_stati.sql

-- Sensei: Show specific course/lesson status report for a learner
--
-- Substitute table names and user id to match your setup

SELECT u.ID, COUNT(c.comment_type) AS `cnt`, c.comment_type AS `status_type`, c.comment_approved AS `status`
  FROM `wp_users` AS u
JOIN `wp_comments` AS c ON u.ID = c.user_id
WHERE
  c.comment_type IN ('sensei_course_status', 'sensei_lesson_status') AND
  u.ID = 1
GROUP BY u.ID, c.comment_type, c.comment_approved;