Question 132

Top 3 trending countries

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
  • ***** * ***** ** ****** *** *** 3 ********* **** *** ******* *****-****-***** ****** ** *** ******** ********.
  • ******* ****** **** **** ****** 2021 *** **** 2021.
  • ****** ****: ***_***_******** ** ****** * 100.0 / ***_***_******* ** ****

Table 1: affirm_account

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

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


Table 2: affirm_account_detail

**** ******* *** **** ****.

  ***_****     | ***_****
---------------+-------------------
*******_**     | ******
****           | ******* (100)
*****          | ******* (100)
*******        | ******* (2)

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.