Table 1: actor
***_**** | ***_**** -------------+-------------------------- *****_** | ******* *****_**** | **** ****_**** | ****
Premium Access
Unlock this premium 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
***********
- ***** * ***** ** ****** *** ***** **** *** *** **** **** ** *** ***** *** ******** ** *** **** *****.
Table 2: film_actor
***** *** ***** *****
***_**** | ***_**** -------------+-------------------------- *****_** | ******** ****_** | ********
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.
10:00
Your results
Run your query to preview results here.
Related Questions
More COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING Questions
| Question | Level | Company | FTPR |
|---|---|---|---|
| Hard | roblox |
10% |
|
| Easy | roblox |
80% |
|
| Medium | roblox |
20% |
|
| Easy | visa |
100% |
|
| Medium | apple |
50% |
|
| Medium | apple |
30% |
|
| Medium | apple |
30% |
|
| Easy | apple |
50% |
|
| Hard | apple |
50% |
|
| Easy | snap |
50% |
|
| Easy | snap |
25% |
|
| Hard | snap |
18% |
|
| Medium |
33% |
||
| Medium |
25% |
||
| Hard |
22% |
||
| Easy |
17% |
||
| Easy |
10% |
||
| Medium | netflix |
49% |
|
| Medium | netflix |
16% |
|
| Easy | netflix |
46% |
|
| Easy | netflix |
19% |
|
| Easy |
23% |
||
| Medium |
11% |
||
| Easy | tiktok |
19% |