Interview Query

Emails Opened

10
Have you seen this question before?

The events table tracks every time a user performs a certain action (like, post_enter, etc.) on a platform.

How many users have ever opened an email?

Example:

Input:

events table

Column Type
user_id INTEGER
created_at DATETIME
action VARCHAR
platform VARCHAR

Output:

Column Type
num_users_open_email INTEGER
Next question: Bootstrapping Samples
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query