← Questions
Unique users per activity and average time on site
0
I was asked this
No reports yet. Sign in to say where you were asked it.
Each record captures one user's action on a website, with the user, the activity and the time. Write code that returns the number of unique users for each activity and the average time users spend on the site. Handle the edge cases in the data (missing or out-of-order records, sessions without an end), and write the SQL version too.
No official answer yet. Write yours on the right and run it.
Nothing published yet.
Sign in to submit your code; every attempt is kept here.
Write and test your solution herePython in your browser, the question's tests level by level, every submission kept for you.Sign in to start coding