Queries for answering credit-related questions

credit-queries.sql

-- Number of students who have submitted credit requests,
-- grouped by course and status.
SELECT
	co.course_key
	, cr.status
	, COUNT(1) AS 'count'
FROM
	credit_creditrequest cr
	JOIN credit_creditcourse co ON cr.course_id = co.id
GROUP BY
	co.course_key
	, cr.status;

-- Number of students eligible for credit, grouped by course
SELECT
	co.course_key
	, COUNT(1) AS 'count'
FROM
	credit_crediteligibility ce
	JOIN credit_creditcourse co ON ce.course_id = co.id
GROUP BY
	co.course_key;