Instruction Write a query to return GROUCHO WILLIAMS' actor_id. Actor's first_name and last_name are all stored as UPPER case in our database, and the database is case sensitive.

Question 17

GROUCHO WILLIAMS’ actor_id

Unsolved Easy Lecture

Instruction

Write a query to return GROUCHO WILLIAMS' actor_id.
Actor's first_name and last_name are all stored as UPPER case in our database, and the database is case sensitive.

Table: actor

actor

actor_id	first_name	last_name
1	PENELOPE	GUINESS
2	NICK	WAHLBERG
3	ED	CHASE
4	JENNIFER	DAVIS
5	JOHNNY	LOLLOBRIGIDA

  col_name   | col_type
-------------+--------------------------
 actor_id    | integer
 first_name  | text
 last_name   | text

Sample results

 actor_id
----------
      1

Solution

postgres

SELECT actor_id 
FROM actor 
WHERE first_name = 'GROUCHO' 
AND last_name = 'WILLIAMS';

Explanation

This query is selecting the actor_id from the actor table where the first name is 'GROUCHO' and the last name is 'WILLIAMS'. It is likely trying to find a specific actor with those exact names.

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 Postgres

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.

More SELECT, WHERE, AND, OR, ORDER BY, LIMIT Questions

Browse Topic Set

Question	Level	Company	FTPR
#228. Analyzing Sequential Purchase Behavior	Hard	microsoft
#227. Aggregate Sale Amounts per Customer	Hard	microsoft
#226. Customer Lifetime Value (CLV) and Segmentation	Hard	microsoft
#225. Customer Behavior Analysis	Hard	microsoft
#224. Categories with High Average Product Price	Medium	microsoft
#223. Cumulative Total Sales by Day	Hard	microsoft
#222. Product Sales Ranking Within Categories	Hard	microsoft
#221. Customers With More Than 5 Products in a Single Transaction	Hard	microsoft
#220. Most Expensive Product in Each Category	Hard	microsoft
#219. Inactive Customers in the New Year of 2024	Medium	microsoft
#218. Total Amount Spent by Each Customer	Medium	microsoft
#217. Most engaged customers	Hard	roblox	10%
#210. Issuer and merchant report	Easy	visa	100%
#200. Last week's absent students	Medium	snap	67%
#175. Employees' email account	Easy	amazon	14%
#152. Salary analysis	Easy	dropbox	20%
#126. Top 3 restaurants	Hard	uber	10%
#111. Second most popular product	Medium	amazon	16%
#92. Acceptance rate first week of 2021	Easy	spotify	14%
#16. Staff who live in Woodridge	Easy		65%
#4. Staff without a profile image	Easy		66%
#3. Top 5 shortest movies	Easy		49%
#2. Top 3 movie categories by sales	Easy		42%
#1. Top store for movie sales	Easy		24%