user: Question: How many numbers are ending in 1 year?
Columns: ['N', 'P', 'Name', 'EU', 'Country', 'Age', 'Type', 'Moving from', 'Transfer window', 'Ends', 'Transfer fee', 'Source']
Types: ['real', 'text', 'text', 'text', 'text', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [5.0, 'DF', 'Fabio Cannavaro', 'EU', 'ITA', 32.0, 'Signed', 'Juventus', 'Summer', '2009', '€10M', 'Realmadrid']
SQL:

assistant: SELECT COUNT("N") FROM "Table" WHERE "Ends" = '1 year';