Database: imdb
Question: Find all actors from Austin born after 1980
SQL:
SELECT name FROM actor WHERE birth_city  =  "Austin" AND birth_year  >  1980;