note/work/教育E卡通/查询成绩sql.md

school_id = '1500000100302563181'; class_id = '1500000100355159224'; user_id = '1500000100355186319';

---

SELECT exam_name, user_name, subject_name, score, standard_score, class_rank, school_rank,exam_time FROM dw_report_user_subject_fact_withmask_month_202510 WHERE class_id = '1500000100355159224' AND user_id = '1500000100355186319'

---