Using SQL to query ADSM

Show the number of nodes per platform, sorted in descending order by number of nodes.

adsm> select platform_name as "Platform", count(*) as "Node count" from nodes group by platform_name order by "Node count" desc