CREATE TABLE visits_restaurant (stuid NUMBER, resid NUMBER, time TIME, spent NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE restaurant (resid NUMBER, resname CLOB, address CLOB, rating NUMBER)
CREATE TABLE type_of_restaurant (resid NUMBER, restypeid NUMBER)
CREATE TABLE restaurant_type (restypeid NUMBER, restypename CLOB, restypedescription CLOB)

Which student visited restaurant most often? List student's first name and last name.
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
SELECT "student"."fname", "student"."lname" FROM "student" JOIN "visits_restaurant" ON "student"."stuid" = "visits_restaurant"."stuid" GROUP BY "student"."stuid" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY