Here is the query I wrote, and it works correctly in the database. But it doesn’t work in Tableau Prep. How do I rewrite it? What are the syntax rules to make it work?

WITH Duplicates AS 
(
    SELECT player_id
    FROM player_agg
    GROUP BY player_id
    HAVING SUM(reg_cnt) = 2
       AND COUNT(DISTINCT license) = 2
),
FilteredRows AS 
(
    SELECT m.*
    FROM player_agg m
    JOIN Duplicates ip ON m.player_id = ip.player_id
    WHERE (m.reg_cnt = 1 AND m.license = 'COM')
       OR m.reg_cnt <> 1
)
SELECT *
FROM FilteredRows

Working query in tableau prep