Unique users per activity and average time on site
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.
GoogleTechnical phone screenNo answer yet. Write the first one; the best answer gets endorsed.