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