CREATE TABLE table_name_47 (year VARCHAR, award VARCHAR)

How many years has the Mercury Prize award been given?
SELECT COUNT(year) FROM table_name_47 WHERE award = "mercury prize"
SELECT COUNT("year") FROM "table_name_47" WHERE "award" = "mercury prize"