Yes, please
select city_code from student where fname = "Linda" and lname = "Smith"
What are the first and last names of all students with the sex "F"?
select fname,lname from student where sex = "F"
What are their city codes?
select city_code from student where sex = "F"
What is the name of the oldest student?
select fname,lname from student order by age desc limit 1