CREATE TABLE table_42563 ("1861" FLOAT, "1866" FLOAT, "1872" FLOAT, "1876" FLOAT, "1881" FLOAT, "1886" FLOAT, "1891" FLOAT)

What is the sum of 1886(s), when 1886 is greater than 1070, and when 1891 is less than 1946?
SELECT SUM("1886") FROM table_42563 WHERE "1866" > '1070' AND "1891" < '1946'
SELECT SUM("1886") FROM "table_42563" WHERE "1866" > '1070' AND "1891" < '1946'