CREATE TABLE table_name_52 (time VARCHAR2, rank VARCHAR2, lane VARCHAR2, nationality VARCHAR2)

What is the total time of the athlete from Canada with a lane less than 8 and a rank less than 8?
SELECT COUNT(time) FROM table_name_52 WHERE lane < 8 AND nationality = "canada" AND rank < 8
SELECT COUNT("time") FROM "table_name_52" WHERE "canada" = "nationality" AND "lane" < 8 AND "rank" < 8