Instruction Write a query to return the number of actors whose first name starts with 'A', 'B', 'C', or others. The order of your results doesn't matter. You need to return 2 columns: The first column is the group of actors based on the first letter of their first_name, us…

Question 13

Actors' first name

Unsolved Medium Lecture

Premium Access

***********

***** * ***** ** ****** *** ****** ** ****** ***** ***** **** ****** **** '*', '*', '*', ** ******.
*** ***** ** **** ******* *****'* ******.
*** **** ** ****** 2 *******:
*** ***** ****** ** *** ***** ** ****** ***** ** *** ***** ****** ** ***** *****_****, *** *** *********: '*_******', '*_******', '*_******', '*****_******' ** ********* ***** ******.
****** ****** ** *** ****** ** ****** ***** ***** **** ******* *** *******.

Table: actor

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

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.

10:00

Timer

Your results

Run your query to preview results here.

Question	Level	Company	FTPR
#178. Members who worked at both Microsoft and Google	Medium	linkedin	34%
#177. Purchases by platform report	Medium	amazon	10%
#176. Employees' annual bonus	Easy	amazon	12%
#160. Sellers with no sales by day	Hard	ebay	11%
#156. Cancellation rate by unbanned users	Hard	lyft	15%
#155. Driver with the highest cancellation rate	Easy	lyft	24%
#151. Salary report	Easy	dropbox	18%
#138. Happy restaurants	Easy	doordash	14%
#136. Extremely late orders	Easy	doordash	11%
#131. Churned accounts	Hard	affirm	10%
#102. Histogram by visit session duration	Hard	google	17%
#35. Film length report	Easy		27%
#34. Stocked up movies	Easy		27%
#33. Returning customers	Medium		8%
#32. Unpopular movies	Hard		17%
#31. Movies that have not been returned	Easy		26%
#30. Inactive customers in May	Easy		22%
#29. Second highest spend customer	Medium		14%
#28. Film with the second largest cast	Medium		26%
#27. Film with the largest cast	Easy		27%
#26. Second shortest film	Easy		30%
#25. Shortest film	Easy		46%
#24. Films with more than 10 actors	Medium		19%
#22. Average cost per rental transaction	Easy		42%