Daily Logins
Start Timer
0:00:00
Let’s say we are given a table user_logins.
Using this table, calculate how many users logged in an identical number of times on January 1st, 2022.
For example, it may be the case that on that date three users logged in seven times, four users logged in five times, two users logged in ten times, etc.
Example:
Input:
user_logins table
| Column | Type |
|---|---|
id |
INTEGER |
user_id |
INTEGER |
login_date |
DATETIME |
Output:
| Column | Type |
|---|---|
number_of_logins |
INTEGER |
number_of_users |
INTEGER |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments