Recursive CTE OR multi-step aggregation depending on solution choice. Practice deriving cross-marketplace twin pairs from product_title equality, computing per-side revenue, and ranking pairs by total revenue. Reveals which cannibalized listings split revenue evenly vs concentrate on one marketplace.