CREATE TABLE table_204_698 (id NUMBER, "name" CLOB, "lifetime" CLOB, "nationality" CLOB, "notable as" CLOB, "notes" CLOB)

how old was pierre vallieres before he died ?
SELECT "lifetime" - "lifetime" FROM table_204_698 WHERE "name" = 'pierre vallieres'
SELECT "lifetime" - "lifetime" FROM "table_204_698" WHERE "name" = 'pierre vallieres'