CREATE TABLE table_79140 ("Pick #" FLOAT, "Player" CLOB, "Nationality" CLOB, "Position" CLOB, "Team from" CLOB, "League from" CLOB)

What is the total pick # for the D position from a team from Chilliwack Bruins?
SELECT SUM("Pick #") FROM table_79140 WHERE "Position" = 'd' AND "Team from" = 'chilliwack bruins'
SELECT SUM("Pick #") FROM "table_79140" WHERE "Position" = 'd' AND "Team from" = 'chilliwack bruins'