Position: Data Analyst
How was the interview process? What was it like?
Show songId that exist at both tables, only x table, and only y table.
What technical questions were asked?
What was one of your solutions?
with subquery1 as (
select userId, min(playDate) min_playDate, songId
group by userId, songId
select a.userId, a.min_playDate, a.songId, a.songOrder
select userId, min_playDate, songId, row_number() over(partition by userId order by min_playDate) songOrder
where a.songOrder = 3