SQL Queries - CAST Central Base - SQL Queries on Metrics - Number of violation occurrences by quality rule

SELECT distinct
    dob.object_name,
                dmr.snapshot_id,
                dss.snapshot_date,
                dmr.metric_id,
                dmt.metric_name,
                count(DISTINCT dcb.local_position_id) bookmark_count         
FROM dss_metric_results dmr,
    dss_code_bookmarks dcb,
    dss_metric_types dmt,
    dss_snapshots dss,
    dss_objects dob
WHERE dcb.position_id=dmr.position_id
  AND dmr.metric_id=dmt.metric_id
  AND dss.snapshot_id=dmr.snapshot_id
  AND dob.object_type_id = -102 and dob.object_id = dss.application_id
  AND dmr.snapshot_id=
    (SELECT max(snapshot_id)
    FROM dss_snapshots)
GROUP BY dmr.metric_id,
        dmt.metric_name,
        dmr.snapshot_id,
        dss.snapshot_date,
  dob.object_name