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)