I made this project to analyze Ontario electricity demand, generation by fuel type, and market price patterns using public IESO data. The project is kept simple on purpose: Python ETL, PostgreSQL ...

ROW_NUMBER() OVER (PARTITION BY s.class_id ORDER BY AVG(g.grade_point) DESC NULLS LAST) as class_rank, ROW_NUMBER() OVER (ORDER BY AVG(g.grade_point) DESC NULLS LAST) as overall_rank, -- 计算各等级成绩数量 ...