注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
老在地里看大家的面经这次分享一个 今天刚面的 Mailchimp 的product analyst technical interview:
题目如下:
Questions
1. Explain the difference between a LEFT JOIN and an INNER JOIN
2. Explain how to achieve the same effect of an INNER JOIN with a LEFT JOIN
3. Tell me about a time when you needed to learn a new piece of SQL logic
4. What’s one of the coolest analysesql to designate if the campaign was sent before May 1, 2019 or After May 1, 2019 and count the number of users by those 2 groups.
3. Write pseudo-sql to return a count of unique user_ids based on the month their campaign was created.
. ----
-baidu 1point3acres
|