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

How long does student Linda Smith spend on the restaurant in total?
SELECT SUM(spent) FROM student JOIN visits_restaurant ON student.stuid = visits_restaurant.stuid WHERE student.fname = "Linda" AND student.lname = "Smith"
SELECT SUM("spent") FROM "student" JOIN "visits_restaurant" ON "student"."stuid" = "visits_restaurant"."stuid" WHERE "Linda" = "student"."fname" AND "Smith" = "student"."lname"