To 🔥 celebrate the holiday season, Also check out our NEWLY launched Annual plan (Up to 50% off). Use coupon code THANKSGIVING15 and enjoy additional 15% off all paid plans. Coupon expires at 2020/11/30 .
17. GROUCHO WILLIAMS’ actor_id easy

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

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

  

Sample results

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

Subscribe for solution