Table 1: apple_search
****** ** ** *** ********* ** ******* ******: --0: *******, 1, *******
***_**** | ***_**** -------------------------+-------------------------- ******_** | **** **_*******_******_** | ******** --0: *******, 1, *******
Question 208
Top 3 urls by testing groups
Premium Access
Unlock this Apple 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 ******* (******* ** ***** ****) ** **** ******* ******
Table 2: apple_search_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.
15:00
Your results
Run your query to preview results here.