Liker's Likers
Start Timer
0:00:00
A dating website’s schema is represented by a table of people that like other people. The table has three columns. One column is the user_id, another column is the liker_id which is the user_id of the user doing the liking, and the last column is the date time that the like occurred.
Write a query to count the number of liker’s likers (the users that like the likers) if the liker has one.
Example:
Input:
likes table
| Column | Type |
|---|---|
user_id |
VARCHAR |
created_at |
DATETIME |
liker_id |
VARCHAR |
Output:
| Column | Type |
|---|---|
user |
VARCHAR |
count |
INTEGER |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments