Distinct pages per user

Distinct pages per user

From sessions(user_id, page), for each user_id build a sorted array of the distinct pages they visited. Output columns user_id and pages (an ascending-sorted array of distinct page values). Order the result by user_id ascending.

Exemplo de resposta esperada

user_idpages
10[/catalog, /home]
11[/home]
12[/pricing]
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid