SQL exercises on movie Database: Find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'
SQL movie Database: Basic Exercise-10 with Solution
10. Write a query in SQL to find the ID number for the actor whose first name is 'Woody' and the last name is 'Allen'.
Sample table: actor
SELECT act_id FROM actor WHERE act_fname='Woody' AND act_lname='Allen';
act_id -------- 111 (1 row)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?