Interview with Intuit as Senior Business Data Analyst. 75 mins interview. First 40-45 mins technical and behavioral type questions. Started the interview with an introduction followed by the below questions.
a). Tell me a time when you used ML/AI in a project
b). Tell me a time when you worked on a project from start to end
c). How do handle a customer/stakeholder who comes from a non-technical background
d). Tell me a time when you made some recommendations and influenced the stakeholders to go ahead with that recommendation
e). Tell me a time when you took a risk, you went ahead with that and did the risk pay off or it didn't and would have taken a moment today to go back and do something differently.

Rest 30 - 35 mins for the below Sql questions.

Table name: company
+------------+-------------+-------------------+------------------+------------------+
| companyid | signupdate | subscriptiondate | terminationdate |
+------------+-------------+-------------------+------------------+------------------+
| 13343128 | 2020-02-13 | 2020-02-14 | NULL |
| 13343124 | 2020-02-13 | 2020-02-14 | NULL |
| 13343100 | 2020-02-13 | 2020-02-14 | NULL |
| 13343090 | 2020-02-13 | NULL | 2020-02-13 |
| 13343074 | 2018-02-13 | 2018-02-14 | NULL |
| 13342758 | 2018-03-23 | 2018-03-24 | NULL |
| 13342732 | 2018-04-05 | 2018-04-05 | NULL |
| 13342730 | 2018-09-13 | NULL | 2018-09-13 |
| 11342720 | 2017-01-05 | 2017-01-06 | 2018-02-13 |
| 11343128 | 2017-02-08 | 2017-02-08 | 2018-08-13 |
| 11342610 | 2017-03-23 | 2017-04-23 | 2018-11-21 |
| 11342720 | 2017-03-29 | 2017-03-30 | NULL |
| 11352870 | 2018-12-03 | 2018-12-03 | 2019-12-13 |
| 11353720 | 2018-12-13 | NULL | NULL |
| 12342720 | 2018-12-21 | 2019-01-20 | 2020-02-13 |

1.a Calculate Churn rate using company level table with subscriptiondate and terminationdate?

Churn Rate = Customer that churned in period / Total Customers at the start of period

1.b How to build a monthly retention curve for new users? Cohorted 30, 60, 90 day, 6month, 1 year retention rates using company level table with signupdate and terminationdate ?

Table A: User_Scores
UserID, UpdatedDate, Score [0,400]
X, '2020-01-15', 37
X, '2020-02-03', 400
X, '2020-02-07', 327
X, '2020-05-29', 321
X, '2020-08-01', 244

Table B: Interactions
UserID, EventDate, EventType, Offer
X, '2020-03-01', View, AA
X, '2020-03-01', Click, AA
X, '2020-04-07', View, BB
X, '2020-04-28', View, FF
X, '2020-06-03', View, FF
X, '2020-06-03', Click, FF

Based on the data provided, construct a SQL query that returns CTR% (sum(clicks) / sum(views)) by different score bins of 200 ('0-200', '201-400')

Expected Output:
score_bins, ctr
‘0-200’, X%
‘201-400’, X%