Instruction Write a query to return the total number of actors using UNION. Actor who appeared in both tv and movie has the same value of actor_id in both actor_tv and actor_movie tables.

Question 57

Total number of actors (with UNION)

Unsolved Easy Lecture

Premium Access

***********

***** * ***** ** ****** *** ***** ****** ** ****** ***** *****.
***** *** ******** ** **** ** *** ***** *** *** **** ***** ** *****_** ** **** *****_** *** *****_***** ******.

Table 1: actor_movie

****** *** ******** ** * *****.

  ***_****  | ***_****
------------+-------------------
 *****_**   | *******
 *****_**** | ********* *******
 ****_****  | ********* *******

Table 2: actor_tv

****** *** ******** ** * ** ****.

  ***_****  | ***_****
------------+-------------------
 *****_**   | *******
 *****_**** | ********* *******
 ****_****  | ********* *******

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

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

Timer

Your results

Run your query to preview results here.

Question	Level	Company	FTPR
#129. Top 3 and bottom 3 courier	Medium	uber	9%
#104. MAU: Monthly active users	Easy	google	20%
#94. Top 3 products vs. bottom 3 products	Medium	amazon	7%
#87. Top song in the US and UK	Medium	spotify	9%
#47. Actors and customers whose first names end in 'D'.	Easy		40%
#46. Actors and customers whose last name starts with 'A'	Easy		31%