map control parts to test parts

SQL_map.sql

SELECT *
FROM 
(
SELECT TEST_DEVICE, DEVICE_OS_TEST, USAGE_TEST,
       CONTROL_DEVICE, DEVICE_OS_CTRL, USAGE_CTRL,
       RANK () OVER (PARTITION BY TEST_DEVICE ORDER BY EUCLEDIAN_DEV_5 ) AS DEV_RANK_5,
       RANK () OVER (PARTITION BY TEST_DEVICE ORDER BY EUCLEDIAN_DEV_3 ) AS DEV_RANK_3,
       RANK () OVER (PARTITION BY TEST_DEVICE ORDER BY EUCLEDIAN_DEV_1 ) AS DEV_RANK_1       
FROM EUCLIDEAN_TABLE
)
WHERE DEV_RANK_5 IN ('1','2','3') OR DEV_RANK_3 IN ('1','2','3') OR DEV_RANK_1 IN ('1','2','3');