CREATE TABLE table_name_78 (bronze NUMBER, total VARCHAR2, rank VARCHAR2, nation VARCHAR2)

What is the average Bronze, when Rank is greater than 6, when Nation is Italy (ITA), and when Total is less than 1?
SELECT AVG(bronze) FROM table_name_78 WHERE rank > 6 AND nation = "italy (ita)" AND total < 1
SELECT AVG("bronze") FROM "table_name_78" WHERE "italy (ita)" = "nation" AND "rank" > 6 AND "total" < 1