CREATE TABLE table_name_2 (total INT, player VARCHAR, scottish_cup VARCHAR)

What is the average total of player Simon Donnelly, with a Scottish Cup greater than 0?
SELECT AVG(total) FROM table_name_2 WHERE player = "simon donnelly" AND scottish_cup > 0
SELECT AVG("total") FROM "table_name_2" WHERE "player" = "simon donnelly" AND "scottish_cup" > 0