How To Create User Profiles in SQL

You might get this task on your next SQL interview.

User profiling is a very common type of data analysis, which helps you segment a user base into fractions to learn and understand customer type and behavior.  

For this exercise, we will take a look at user actions across the webpage and bucket them into categories, which may be used for additional deep-dive analysis, A/B testing, or user research later …