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