Great job and work on the diagrams!

This is a very solid submission. The biggest recurring issue is adding unnecessary GROUP BY clauses (ROW_NUMBER query, last SELECT in temp tables), which could drop rows unintentionally. The COUNT() problem also doesn’t fully follow the “windw function” requirement. But your intent is clear, and almost all queries return correct results.