Database: pets_1
Question: What is the id of the pet owned by the student whose last name is 'Smith'?
SQL:
SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid WHERE T1.Lname  =  'Smith'