gistfile1.txt

(tc/concat
                           (-> designation-capacities
                               (tc/drop-rows #(#{"St Teresas/Moorgate/Blackrod Church" "Green Fold"} (:school %))))
                           (-> designation-capacities
                               (tc/select-rows #(#{"St Teresas/Moorgate/Blackrod Church" "Green Fold"} (:school %)))
                               (tc/group-by :calendar-year)
                               (tc/aggregate {:capacity #(reduce + (% :capacity))})
                               (tc/rename-columns {:$group-name :calendar-year})
                               (tc/add-columns {:school "Green Fold/St Teresas/Moorgate/Blackrod Church"
                                                :setting "MSS/RP"
                                                :phase "primary"
                                                :designation "ASD"
                                                :setting-phase "Primary age ASD"})))