user: Question: Which Year has a Borough of Harrogate, and a Rank smaller than 6, and a Definition of Civil Parish?
Columns: ['Rank', 'Town', 'Population', 'Year', 'Borough', 'Definition']
Types: ['real', 'text', 'real', 'real', 'text', 'text']
Sample row: [1.0, 'Harrogate', 71594.0, 2001.0, 'Harrogate', 'Town']
SQL:

assistant: SELECT "Year" FROM "Table" WHERE "Borough" = 'Harrogate' AND "Rank" < 6.0 AND "Definition" = 'Civil Parish';