Database: imdb
Question: Find all the female actors from Austin
SQL:
SELECT name FROM actor WHERE birth_city  =  "Austin" AND gender  =  "female";