Select  student_id,teacher_id
          ,student.fullname_decrypted  as student_name
          ,teacher.fullname_decrypted  as teacher_name
          ,student.loginname_decrypted as student_loginname
          ,student.sis_sourceid as student_sis_sourceid
          ,student.sis_user_identifier as student_sis_user_identifier
          ,assessment_id, product_id,district_id, school_id
          ,org.organizationname as school_name
          ,class_id,cl.classtitle as class_name
          ,standard_id,framework_id, fw.frameworkname as standards_set_name
          ,std.description as standard_description, std.code as standard_code
          , prod.rumbaproducttitle as product_name, prod.program as product_family
          ,sum_usr_score,sum_max_score,score_perc
              from (
              Select user_id student_id,district_id, school_id
                ,content_id, assessment_id, product_id,class_id
                ,standard_id,framework_id
                ,enr.userid teacher_id,sum_usr_score,sum_max_score,score_perc
                ,row_number()over(partition by class_id order by enr.scdtimestamp desc ) rnk
              from (
                              SELECT fact.user_id,fact.district_id, fact.school_id
                                      ,fact.content_id, fact.assessment_id, fact.product_id
                                      ,fact.class_id,std_h.standard_id, std_h.framework_id
                                      ,sum(fact.measure_userscore) as sum_usr_score, sum(fact.measure_maxscore) as sum_max_score
                                      ,(sum(fact.measure_userscore) / sum(fact.measure_maxscore)) * 100 as score_perc
                      FROM report.v_standard_scores fact
                              INNER JOIN dw.dimcontent cont on fact.assessment_id=cont.contentassetid
                              INNER JOIN report.standard_hierarchy std_h ON fact.content_id = std_h.content_id
                              INNER JOIN report.dim_date dd ON fact.date_id = dd.date_id
                               Where fact.district_id in  ('8a9480bd28df05e40128e3f7f85d1552')
                                       and  cont.includeinmastery = 'yes'
                                       and ((( dd.date_value ) >= ((DATEADD(month,-2, DATE_TRUNC('month', DATE_TRUNC('day',GETDATE())) ))) AND ( dd.date_value ) < ((DATEADD(month,3, DATEADD(month,-2, DATE_TRUNC('month', DATE_TRUNC('day',GETDATE())) ) )))))
                                  GROUP BY user_id,district_id, school_id
                                        ,fact.content_id, fact.assessment_id, fact.product_id, fact.class_id
                                        ,std_h.standard_id, std_h.framework_id
                        ) inner_qry
                      INNER JOIN dw.dimuserenrollment enr ON inner_qry.class_id = enr.enrolledtoid AND upper(enr.roletype)='TEACHER'
              ) outer_qry
              INNER JOIN dw.dimframework fw ON outer_qry.framework_id = fw.frameworkid
              INNER JOIN dw.dimuser teacher ON outer_qry.teacher_id=teacher.userid
              INNER JOIN dw.dimuser student ON  outer_qry.student_id=student.userid
              INNER JOIN dw.dimorganization org ON  outer_qry.school_id =org.organizationid
              INNER JOIN dw.dimstandard std ON outer_qry.standard_id =std.standardid
              INNER JOIN dw.dimclass cl  ON outer_qry.class_id=cl.classid
              INNER JOIN  nexgen.dimrumbaproduct prod ON prod.rumbaproductid = outer_qry.product_id
              where rnk=1
              group by student_id,teacher_id, student_name, teacher_name,student_loginname
              ,student_sis_sourceid, student_sis_user_identifier,assessment_id, product_id
              ,district_id, school_id, school_name,class_id, class_name,standard_id,framework_id
              ,standards_set_name,standard_description, standard_code, product_name, product_family
              ,sum_usr_score,sum_max_score,score_perc