SELECT Address FROM Restaurant WHERE ResName = "Subway";
What is the address of the restaurant Subway?
create table Student (
        StuID        INTEGER PRIMARY KEY,
        LName        VARCHAR(12),
        Fname        VARCHAR(12),
        Age      INTEGER,
        Sex      VARCHAR(1),
        Major        INTEGER,
        Advisor      INTEGER,
        city_code    VARCHAR(3)
 );
create table Restaurant (
       ResID       INTEGER PRIMARY KEY,
       ResName     VARCHAR(100),
       Address     VARCHAR(100),
       Rating INTEGER
);
create table Type_Of_Restaurant (
       ResID       INTEGER,
       ResTypeID   INTEGER,
       FOREIGN KEY(ResID) REFERENCES Restaurant(ResID),
       FOREIGN KEY(ResTypeID) REFERENCES Restaurant_Type(ResTypeID)
);
create table Restaurant_Type (
       ResTypeID            INTEGER PRIMARY KEY,
       ResTypeName          VARCHAR(40),
       ResTypeDescription   VARCHAR(100)
);
create table Visits_Restaurant (
       StuID      INTEGER,
       ResID      INTEGER,
       Time       TIMESTAMP,
       Spent      FLOAT,
       FOREIGN KEY(StuID) REFERENCES Student(StuID),
       FOREIGN KEY(ResID) REFERENCES Restaurant(ResID)
);
INSERT into Student values ( 1001, 'Smith', 'Linda', 18, 'F', 600, 1121,'BAL');
INSERT into Restaurant values ( 1, 'Subway', '3233 St Paul St, Baltimore, MD 21218', 3);
INSERT into Restaurant_Type values ( 1, 'Sandwich', 'Simplest there is.');
INSERT into Type_Of_Restaurant values (1, 1);
INSERT into Visits_Restaurant values (1001, 1, '2017-10-09 18:15:00', 6.53);
INSERT INTO Student VALUES [(1001, 'Smith', 'Linda', 18, 'F', 600, 1121, 'BAL'), (1002, 'Kim', 'Tracy', 19, 'F', 600, 7712, 'HKG')]
INSERT INTO Restaurant VALUES [(1, 'Subway', '3233 St Paul St, Baltimore, MD 21218', 3), (2, 'Honeygrow', '3212 St Paul St, Baltimore, MD 21218', 4)]
INSERT INTO Type_Of_Restaurant VALUES [(1, 1), (2, 2)]
INSERT INTO Restaurant_Type VALUES [(1, 'Sandwich', 'Simplest there is.'), (2, 'Stir-fry', 'Classic Chinese cooking.')]
INSERT INTO Visits_Restaurant VALUES [(1001, 1, '2017-10-09 18:15:00', 6.53), (1032, 2, '2017-10-08 13:00:30', 13.2)]