Top Landing Pages

The landing page of a session is the page of its earliest visit. Return each landing page with the number of sessions that started on it, ordered by count descending then page.

Table schema

Visits(session_id INT, page VARCHAR(20), ts INT)

Sample data

session_id | page | ts
1 | home | 1
1 | pricing | 2
2 | pricing | 1
3 | home | 1