how to count total number of devices by location

hi all 

how to divide by location . i have created a  custom property call (locations) and i wan to divide all devices by locations and total number of device by location

. example :   London , 100 

                    England   110 

            total  devices   210    

select count(1) as kpi_number from orion.nodes

Parents Reply Children