10 Duplicates

-- 10_duplicates: Locate repeated source identifiers
-- Read-only reference query. Setup must be loaded first.
SELECT source_order_id,COUNT(*) AS versions
FROM aabha_sql.raw_orders GROUP BY source_order_id HAVING COUNT(*)>1 ORDER BY source_order_id;