Table 1: ap_customer
********'* ******** **** ****.
***_**** | ***_**** ---------------+------------------- ** | ****** ****_**** | ****
Question 143
Customer purchase report
Premium Access
Unlock this Afterpay 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
-
***** * ***** **** ******* ******** **, ********* ****, ******** **, ******** **** *** ****** ** *********.
-
*** *** ********* 10 ********_**:
-
8001, 8002, ..., 8010
-
Table 2: ap_merchant
********* **** *********** ******** ******** ** ***** ******** ********.
***_**** | ***_**** -----------------+--------------------- ** | ****** **** | ****
Table 3: ap_order
********'* ***** *****
***_**** | ***_**** ----------------+------------------- ** | ****** **** | **** ********_** | ****** ********_** | ****** *****_******* | *******(10) ********_****** | *****
Sample results
Last Submission
postgresNo 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.
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.
5:00
Your results
Run your query to preview results here.