CREATE TABLE table_72487 ("N" FLOAT, "P" CLOB, "Name" CLOB, "EU" CLOB, "Country" CLOB, "Age" FLOAT, "Type" CLOB, "Moving from" CLOB, "Transfer window" CLOB, "Ends" CLOB, "Transfer fee" CLOB, "Source" CLOB)

How many numbers are ending in 1 year?
SELECT COUNT("N") FROM table_72487 WHERE "Ends" = '1 year'
SELECT COUNT("N") FROM "table_72487" WHERE "Ends" = '1 year'