quiz_alignments.sql

SELECT date_trunc('month', date(q.created_at)) AS month, COUNT(DISTINCT r.artifact_id) AS with_outcomes, COUNT(DISTINCT q.id) AS total FROM quizzes q
LEFT OUTER JOIN learning_outcome_results r ON (r.g_shard_id = q.g_shard_id AND r.artifact_id = q.id AND r.artifact_type = 'Quizzes::QuizSubmission')
WHERE date(q.created_at) > date('2017-07-01')
GROUP BY date_trunc('month', date(q.created_at))

rubric_alignments.sql

SELECT date_trunc('month', date(ra.created_at)) AS month, SUM(IF(regexp_like(ra.data, 'learning_outcome_id:\s+\d'), 1, 0)) AS with_outcomes, COUNT(ra.id) AS total
FROM rubric_assessments ra
WHERE date(ra.created_at) > date('2017-07-01')
GROUP BY date_trunc('month', date(ra.created_at))