Database: restaurant_1
Question: Which student visited restaurant most often? List student's first name and last name.
SQL:
SELECT Student.Fname , Student.Lname FROM Student JOIN Visits_Restaurant ON Student.StuID = Visits_Restaurant.StuID GROUP BY Student.StuID ORDER BY count(*) DESC LIMIT 1;