Strategic Affiliates Initiative KPIs (Key Performance Indicators), with SQL

Here is a set of KPI reports for a client's Strategic Affiliates Initiative, with SQL below (to demonstrate my skill level with SQL selects):