1. the challenge
Tell me about the challenge you had with your co-worker and how you handled it.
mentioned blockers I had received in product release meetings from a particular individual
mentioned blockers I had received in product release meetings from a particular individual
2. General SQL questions
| 1. How many new subscribers have we received every month starting Jan 2017?
2. How does that metric compare to the same month prior year'
3.What is the conversion rate of signups for Dec 2018?
4. There' s another table (Free Subs) with companyIDs that got a free subscription.How do we exclude them from our previous metrics?
Table:
+---------+---------+---------------+--------------+---+------+|
companyid I signupdate l subscriptiondate l terminationdate l year l month
+---------+---------+---------------+--------------+---+------+|
|13343128 | 2020-02-13 |2020-02-14 I NULL || 13343124 | 2020-02-13 I 2020-02-14 |NULL || 13343100 I 2020-02-13 I 2020-02-14 I NULL ll 13343090 | 2020-02-13 I NULL || 2020-02-13 || 13343074 I 2018-02-13 I 201 8-02-14I NULL ll 13342758 | 2018-03-23 I 2018-03-24 I NULL || 13342732 | 2018-04-05 | 2018-04-05 I NULL || 13342730 |2018-09-13 |NULL |I 2018-09-13 || 1342720 | 2017-01-05 |2017-01-06 I 2018-02- 13 || 11343128 |2017-02-08 |2017-02 -08 I 2018-08-13 || 11342610 |2017-03 -23 | 2017-04-23I 2018-11-21 || 11342720 | 2017-03-29 |2017-03-30
2. How does that metric compare to the same month prior year'
3.What is the conversion rate of signups for Dec 2018?
4. There' s another table (Free Subs) with companyIDs that got a free subscription.How do we exclude them from our previous metrics?
Table:
+---------+---------+---------------+--------------+---+------+|
companyid I signupdate l subscriptiondate l terminationdate l year l month
+---------+---------+---------------+--------------+---+------+|
|13343128 | 2020-02-13 |2020-02-14 I NULL || 13343124 | 2020-02-13 I 2020-02-14 |NULL || 13343100 I 2020-02-13 I 2020-02-14 I NULL ll 13343090 | 2020-02-13 I NULL || 2020-02-13 || 13343074 I 2018-02-13 I 201 8-02-14I NULL ll 13342758 | 2018-03-23 I 2018-03-24 I NULL || 13342732 | 2018-04-05 | 2018-04-05 I NULL || 13342730 |2018-09-13 |NULL |I 2018-09-13 || 1342720 | 2017-01-05 |2017-01-06 I 2018-02- 13 || 11343128 |2017-02-08 |2017-02 -08 I 2018-08-13 || 11342610 |2017-03 -23 | 2017-04-23I 2018-11-21 || 11342720 | 2017-03-29 |2017-03-30
3. 用R/Python做过的分析
举例介绍一个用R/Python做过的分析
4. 用到tableau的project
举例介绍一个用到tableau的project
5. The challenge
Tell me about the challenge you had with your co-worker and how you handled it