state-department-data

Custom SQL query returning 20 rows (hide)

select sum([training:total_cost]) as "Training cost FY 2018-2019", [training:recipient_unit] as "Student Unit" from [training-data] where [training:source] = "8d439057-bc2d-4141-8ff3-48d6842150eb" and [training:delivery_unit] IS NOT NULL group by [training:recipient_unit] order by sum([training:total_cost]) desc limit 20

Query parameters

total_cost

recipient_unit

source

delivery_unit