Session Data Analysis.

Session Data Analysis.

Additional context: Let's imagine you have a table with 1 row per session. The two fields you will be using are 'country' (country of the user) and 'session_time' (session length in seconds). 1) What is the average session time of sessions longer than 3 minutes?. 2) I want to make a histogram of session lengths using bins of 5 minutes. How do I get the data to plot it? (output: 1 column is bins of 5 minutes, 1 column is count of sessions in that bin). 3) how do I find similar countries, where similar countries is defined as countries that have within 10% of the number of sessions? (output: 1 column for country a and 1 column for country b).