Question 131

Churned accounts

Premium Access

Unlock this Affirm interview question.

Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.

  • 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.

Copied
Expected results

Submit a query to compare against expected output.