question: What is the id of the pet owned by the student whose last name is 'Smith'?
#1 return students 
#2 return last names of  #1 
#3 return #1 where #2 is  'Smith 
#4 return pet owned by #3 
#5 return id of  #4