Interview Query

Like Tracker

13
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.

Write a query to determine how many different users gave a like on June 6, 2020. 

Example:

Input:

events table

Column Type
user_id INTEGER
created_at DATETIME
action VARCHAR
platform VARCHAR

Output

Column Type
num_users_gave_like INTEGER
Next question: Target Whitepages
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query