Table 1: twitter_campaigns
**** ** *********** ********* ******* ** ** ** ******* ** *******.
***_**** | ***_**** --------------+-------------------------- *******_** | ****** ********_** | ****** ********_****| *******(30)
Question 190
Twitter campaign spend report
Premium Access
Unlock this Twitter 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
*******
- **** ** * ******-** ******** ** ******** #189
- *******'* ***** *** ****** ** ********** ******* ** **** **** *** ****** ** ********* ** *******;
- * ******** *** * ****** ********_** *** * ****** ********_****;
- **** * ******** ** *******, *** ********_**** *** *** ** *******.
***********
- ***** * ***** ** ****** *** *********:
- ********_**, ********_****, ********_*****_****, *****_***** (******** ***** ***** ** ***** 2022)
- ********_*****_**** ** *** ***** *** **** >0 *****.
- ** * ******** *** *** *******, ****** **** *** ********_*****_****, *** 0 *** *****_*****.
Table 2: twitter_campaign_spend
***** ** ******** ****** ** *******'* ********** ********.
***_**** | ***_**** --------------+-------------------------- ********_** | ****** **** | **** ***** | *****
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.
15:00
Your results
Run your query to preview results here.