CREATE TABLE table_79090 ("Year" FLOAT, "Gold" CLOB, "Silver" CLOB, "Bronze" CLOB, "Notes" CLOB)

WHAT YEAR HAS A BRONZE OF VALENTIN NOVIKOV?
SELECT AVG("Year") FROM table_79090 WHERE "Bronze" = 'valentin novikov'
SELECT AVG("Year") FROM "table_79090" WHERE "Bronze" = 'valentin novikov'