user: ### NOW ANSWER:
Question: What is the sum for the year with a location of Newport, Rhode Island?
Columns: ['Year', 'Country', 'Course', 'Location', 'Total score', 'To par [a ]']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [1895.0, 'England', 'Newport Country Club', 'Newport, Rhode Island', '173', 'n/a']
SQL:

assistant: SELECT SUM("Year") FROM "Table" WHERE "Location" = 'Newport, Rhode Island';