Cacher is the code snippet organizer for pro developers

-- Count Layers per Map document
SELECT
  count(LYR_Name) AS Count,
  LYR_Name,
  LYR_Path
FROM Layers
  --where LYR_Path like 'C:%'
GROUP BY
  LYR_Name,
  LYR_Path
ORDER BY Count
  DESC