Data Analysis Journal

Data Analysis Journal

Share this post

Data Analysis Journal
Data Analysis Journal
User Activity Analysis In SQL - Issue 26
SQL

User Activity Analysis In SQL - Issue 26

A common SQL problem solution and code walk through

Olga Berezovsky's avatar
Olga Berezovsky
Jan 06, 2021
∙ Paid
5

Share this post

Data Analysis Journal
Data Analysis Journal
User Activity Analysis In SQL - Issue 26
Share

Welcome, 2021! 

Thank you for being a supporter of the Data Analysis Journal! Your contribution means the world to me. 

This week I want to share a common SQL question that I often see during technical interviews. It’s somewhere between an intermediate and an advanced level - analyzing user activity by applying SQL rank function. 

Share

🏆 Nailed It

Be prepared f…

Keep reading with a 7-day free trial

Subscribe to Data Analysis Journal to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share