Table:
text: North Yorkshire
Settlements by population
Settlements by population
Rank_ Town Population Year_ Borough Definition
1 Harrogate 71594 2001 Harrogate Town
2 Scarborough 50135 2001 Scarborough Town
3 Acomb 22215 2001 York Town
4 Ripon 15922 2001 Harrogate Civil Parish
5 Northallerton 15741 2001 Hambleton Civil Parish
6 Knaresborough 14740 2001 Harrogate Civil Parish
7 Skipton 14313 2001 Craven Civil Parish
8 Whitby 13594 2001 Scarborough Civil Parish
9 Selby 13012 2001 Selby Civil Parish
10 Richmond 8178 2001 Richmondshire Civil Parish
11 Tadcaster 7000 2001 Selby Civil Parish
12 Norton 6943 2001 Ryedale Civil Parish
13 Pickering 6846 2001 Ryedale Civil Parish
14 Filey 6819 2001 Scarborough Civil Parish
15 Sherburn-in-Elmet 6221 2001 Selby Civil Parish

Question: What year is the highest with more than 13,012 inhabitants and a borough of Richmondshire in North Yorkshire?

Question: How many people live in Norton, North Yorkshire?

Question: What year in North Yorkshire has a borough of Harrogate and a rank less than 6 and a civil parish definition?

Question: Which definition under North Yorkshire has a rank less than 12 and a town of Tadcaster?

Question: What rank is the lowest having a borough of Richmondshire and a population greater than 8,178 in North Yorkshire?