CREATE TABLE table_name_38 (total INT, gold VARCHAR, rank VARCHAR)

Name the average total for gold less than 1 and rank less than 5
SELECT AVG(total) FROM table_name_38 WHERE gold < 1 AND rank < 5
SELECT AVG("total") FROM "table_name_38" WHERE "gold" < 1 AND "rank" < 5