findBorkenSequenceChildSkusQuery.sql

SELECT product_id
FROM (SELECT product_id, MAX(sequence_num) AS "MAX_SEQ", count(*) -1 AS "COUNT"
      FROM (SELECT DISTINCT dcc.product_id, dcc.sequence_num, dcc.sku_id
            FROM dcs_product dc
            INNER JOIN dcs_prd_chldsku dcc ON (dcc.product_id = dc.product_id)
            WHERE dc.asset_version = dcc.asset_version
            AND dc.is_head = 1
            )
      GROUP BY product_id
      )
WHERE max_seq <> count;