Third Unique Song
Given a table of song_plays and a table of users, write a query to extract the earliest date each user played their third unique song.
Example:
Input:
song_plays table
| Columns | Type |
|---|---|
user_id |
INTEGER |
song_name |
TEXT |
date_played |
DATETIME |
users table
| Columns | Type |
|---|---|
id |
INTEGER |
name |
VARCHAR |
Output:
| Columns | Type |
|---|---|
name |
VARCHAR |
date_played |
DATETIME |
song_name |
TEXT |
.....
Loading editor