Как написать self join запрос исключив дубликаты без использования distinct?

WITH users AS (
    SELECT 'user1' name, '2022-01-22' DATE, 'Theme 1' theme UNION ALL
    SELECT 'user1' name, '2022-03-24' DATE, 'Theme 2' theme UNION ALL
    SELECT 'user1' name, '2022-05-26' DATE, 'Theme 3' theme UNION ALL
    SELECT 'user2' name, '2021-01-02' DATE, 'Theme 4' theme UNION ALL
    SELECT 'user2' name, '2021-02-13' DATE, 'Theme 5' theme UNION ALL
    SELECT 'user2' name, '2021-04-25' DATE, 'Theme 6' theme UNION ALL
    SELECT 'user3' name, '2020-05-28' DATE, 'Theme 7' theme UNION ALL
    SELECT 'user3' name, '2020-06-30' DATE, 'Theme 8' theme UNION ALL
    SELECT 'user3' name, '2020-07-05' DATE, 'Theme 9' theme
) SELECT * FROM users;

WITH users AS (
    SELECT 'user1' name, '2022-01-22' DATE, 'Theme 1' theme UNION ALL
    SELECT 'user1' name, '2022-03-24' DATE, 'Theme 2' theme UNION ALL
    SELECT 'user1' name, '2022-05-26' DATE, 'Theme 3' theme UNION ALL
    SELECT 'user2' name, '2021-01-02' DATE, 'Theme 4' theme UNION ALL
    SELECT 'user2' name, '2021-02-13' DATE, 'Theme 5' theme UNION ALL
    SELECT 'user2' name, '2021-04-25' DATE, 'Theme 6' theme UNION ALL
    SELECT 'user3' name, '2020-05-28' DATE, 'Theme 7' theme UNION ALL
    SELECT 'user3' name, '2020-06-30' DATE, 'Theme 8' theme UNION ALL
    SELECT 'user3' name, '2020-07-05' DATE, 'Theme 9' theme
) SELECT * FROM users u1 WHERE NOT EXISTS (SELECT * FROM users u2 WHERE u2.name = u1.name AND u2.DATE < u1.DATE);

SELECT name, "DATE", theme FROM 
(SELECT *, ROW_NUMBER() OVER (Partition BY name ORDER BY "DATE" DESC) N FROM users) AS t
WHERE t.N = 1

SELECT name, "DATE", theme FROM users
ORDER BY ROW_NUMBER() OVER (Partition BY name ORDER BY "DATE" DESC) ASC
FETCH FIRST 1 ROWS WITH TIES