How long did Linda Smith spend at Subway?
select spent from student join visits_restaurant on student.stuid = visits_restaurant.stuid join restaurant on visits_restaurant.resid = restaurant.resid where student.fname = "Linda" and student.lname = "Smith" and restaurant.resname = "Subway";
What time did she arrive?
select time from student join visits_restaurant on student.stuid = visits_restaurant.stuid join restaurant on visits_restaurant.resid = restaurant.resid where student.fname = "Linda" and student.lname = "Smith" and restaurant.resname = "Subway";