SELECT
  `namespace`,
  `group`,
  `resource`,
  COUNT(*),
  MAX(`resource_version`)
FROM `resource`
WHERE 1 = 1
  AND `namespace` = 'default'
GROUP BY 
  `namespace`,
  `group`,
  `resource`
;