By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH sku_match AS (
SELECT 1 AS req_id, 4 AS p_id, 'Match' AS ai_result, 'XAN' AS hash, 'HOW' AS sku UNION ALL
SELECT 1, 4, 'Match', 'XHN', 'HOW' UNION ALL
SELECT 1, 4, 'Non Match', '123', 'HOW'
)
SELECT
sku,
GROUP_CONCAT(CASE WHEN ai_result = 'Match' THEN hash END) AS matched,
GROUP_CONCAT(CASE WHEN ai_result = 'Non Match' THEN hash END) AS non_matched
FROM sku_match
GROUP BY
sku;
| sku | matched | non_matched |
|---|---|---|
| HOW | XAN,XHN | 123 |