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 Dublicates 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 Dublicates 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