create table nfl_stadium_data( stadium varchar(60), seating_capacity INT, location varchar(40), surface varchar(80), roof varchar(30), team varchar(40), opened varchar(10), sport_location_id INT );