SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE table  journey (ID int,    evar  char(10),    event_date date,    ranking  int) 


INSERT INTO journey VALUES 
(1    ,'landing'   ,'2019-01-01',      1   ),
(1    ,'content'   ,'2019-01-02',      2   ),
(1    ,'homepage'  ,'2019-01-03',      3   ),
(2    ,'support'   ,'2019-02-01',      1   ),
(2    ,'content'   ,'2019-02-02',      2   ),
(3    ,'content'   ,'2019-01-23',      1   ),
(3    ,'support'   ,'2019-01-24',      2   );
7 rows affected

SELECT y.journey, RANK() OVER (ORDER BY cnt DESC) as ranking
FROM 
(
    SELECT x.journey, count(*) as cnt
    from 
    (
        SELECT ID, STRING_AGG(RTRIM(evar),',') as journey
        FROM journey
        GROUP BY ID
    ) x
    GROUP BY journey
) y;


journey
ranking


content,support
1

landing,content,homepage
1

support,content
1


INSERT INTO journey VALUES 
(4    ,'landing'   ,'2019-01-01',      1   ),
(4    ,'content'   ,'2019-01-02',      2   ),
(4    ,'homepage'  ,'2019-01-03',      3   );
3 rows affected

SELECT y.journey, RANK() OVER (ORDER BY cnt DESC) as ranking
FROM 
(
    SELECT x.journey, count(*) as cnt
    from 
    (
        SELECT ID, STRING_AGG(RTRIM(evar),',') as journey
        FROM journey
        GROUP BY ID
    ) x
    GROUP BY journey
) y;


journey
ranking


landing,content,homepage
1

support,content
2

content,support
2