CREATE TABLE table_name_5 (lower_index_kcal__nm_3 INT, lower_index_mj__nm_3 VARCHAR, upper_index_kcal__nm_3 VARCHAR)

What is the Lower index Kcal/ Nm 3 entry, for the row with entries of an Upper index Kcal/ Nm 3 smaller than 19,376, and a Lower index MJ/ Nm 3 of 74.54?
SELECT AVG(lower_index_kcal__nm_3) FROM table_name_5 WHERE lower_index_mj__nm_3 = 74.54 AND upper_index_kcal__nm_3 < 19 OFFSET 376
SELECT AVG("lower_index_kcal__nm_3") FROM "table_name_5" WHERE "lower_index_mj__nm_3" = 74.54 AND "upper_index_kcal__nm_3" < 19 OFFSET 376