Write SQL joins, aggregations, and window functions to pull specific operational metrics for Delaware North.