Table 1: employee
******** ***********, ********** **** *** ** *** ***** ****** ******.
***_**** | ***_**** ---------------+------------------- ** | ****** ****_**** | ******* (100) **********_** | *** ****** | *****
Question 153
Project ROI
Premium Access
Unlock this Dropbox 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
- ***** * ***** ** ********* *** *** *** ***** ****** *******.
- *** = ****** / ****
- **** = ******** *** ** *********' ****** ** **** *******.
- ** ******* *** **** ** ** ********, ****** *** ***** ****** ** **** **/*** ***** ** **** ******* ** 365 **** ******** ***/*** ****** ******.
Table 2: project_detail
******* **** ****
***_**** | ***_**** -----------------+--------------------- *******_** | ****** ***** | *******(200) *****_**** | **** ***_**** | **** ****** | *****
Table 3: projects
******** ******* *** ********* *** *** ********** ****.
***_**** | ***_**** -----------------+--------------------- *******_** | ****** ********_** | ******
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.