Question 125
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
• ***** * ***** ** ****** *** ****** ** ****** *********** **** ***** **** 5 ********* ***** *** ****.
Table 1: merchant
* ********* ***** *** *** ******* ******** **** ** * **********.
***_**** | ***_**** -----------------+------------------- ** | ****** ***********_*** | ***** *****_****** | *******(5) ********_****_** | ****** **_****** | ******* *****_******_** | ********* **** | **** ******* | *******(2)
Table 2: trip
**** ***** *** ***** **** **** ********.
***_**** | ***_**** --------------------+------------------- ****_** | ****** **** | **** ****_*****_** | ********* ********_***_*** | *** *****_***_*** | *** **_********_******* | ******* **_********* | ******* **_****_**** | ******* ****_** | ****** **********_** | ****** *******_** | ****** **** | **** ******* | *******(2)
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
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
Run your query to preview results here.
