This assist me in getting the resources for eaxh susciption which is group by it`s resource types

resources

| where subscriptionId == "xxxxxxxx"

| summarize count() by type

| order by count_ desc