Apple Data Analyst | October 2020
?
•Anonymous••Upvote
2
Downvote
Company: Apple
Position: Data Analyst
Location: nan
Level: nan
Outcome: NA
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?
nan
What was one of your solutions?
with subquery1 as (
select userId, min(playDate) min_playDate, songId
from play_tb
group by userId, songId
)
select a.userId, a.min_playDate, a.songId, a.songOrder
from (
select userId, min_playDate, songId, row_number() over(partition by userId order by min_playDate) songOrder
from subquery1
) a
where a.songOrder = 3
Apple
Data Analyst
There's so much more to Interview Query
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est