#837

Show the path the user walked through the site

On the site every page load is recorded as a separate row in events with type page — the page path lives inside payload under the key path. Analytics wants to compose every user's «visit path» as a single string: all their pages joined with an arrow in chronological order, e.g. /home → /pricing → /checkout. For every user with at least one page event, glue their paths into one string with the separator , ordering elements by event time. Sort by user id.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

pathuser_id
/home → /pricing → /home1
/home → /blog2
/home → /pricing → /checkout3

Your query result will appear here