SELECT
    aqr.uid, aqr.type, aqr.District, aqr.Student, aqr.AssessmentQuestion, aqr.AssessmentForm, aqr.SchoolYear, aqr.value, aqr.User, aqr.dateTime
FROM AssessmentQuestionResponse aqr
JOIN AssessmentQuestion aq ON aq.uid = aqr.AssessmentQuestion
JOIN Assessment a ON a.uid = aq.Assessment AND a.type = 14 -- type easyCBM
ORDER BY aqr.uid;


SELECT
    ampr.uid, ampr.type, ampr.District, ampr.Student, ampr.AssessmentQuestion, ampr.AssessmentForm, ampr.SchoolYear, ampr.month, ampr.week, ampr.value, ampr.phasenote, ampr.phaseline, ampr.User, ampr.dateTime
FROM AssessmentMeasureProgressResponse ampr
JOIN AssessmentQuestion aq ON aq.uid = ampr.AssessmentQuestion
JOIN Assessment a ON a.uid = aq.Assessment AND a.type = 14 -- type easyCBM
ORDER BY ampr.uid;