Write a query to return the number of churned accounts in Aug 2021; Churned accounts are those completely removed accounts in Aug 2021; A user can delete a saving account if he created a 'both' account and remain active. For a 'both' account to churn, a user must …

Prev Discuss

Question 131

Churned accounts

Unsolved Hard affirm Lecture

Premium Access

Unlock this Affirm interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

***** * ***** ** ****** *** ****** ** ******* ******** ** *** 2021;
******* ******** *** ***** ********** ******* ******** ** *** 2021;
* **** *** ****** * ****** ******* ** ** ******* * '****' ******* *** ****** ******.
*** * '****' ******* ** *****, * **** **** ****** **** ** *** '********' *** '******' ******** ** 2 ******** **********, *.*., ***** **** ** *** '*******' ******* *** * '****' *******, ** ********** ****** **.

Table: affirm_account

**** ******* ********/******** *******, *** ******* **** *** **** ** *** ** '********', '******', ** '****'.

  ***_****     | ***_****
---------------+-------------------
**             | ******
*******_****   | ******* (20) -- '********', '******', ** '****
******         | ******* (10) --  '*******' ** '*******'
****           | ****

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

15:00

Timer

Your results

Run your query to preview results here.

Question	Level	FTPR
#130. Newly created accounts	Easy	37%
#132. Top 3 trending countries	Medium	9%

Churned accounts

Unlock this Affirm interview question.

More Affirm Questions