CREATE TABLE table_name_7 (year NUMBER, location VARCHAR2)

For how many years was the location at Beijing?
SELECT SUM(year) FROM table_name_7 WHERE location = "beijing"
SELECT SUM("year") FROM "table_name_7" WHERE "beijing" = "location"