list of communities in saskatchewan
according to the list of communities in saskatchewan , among the communities with land area below 10.00 km square , 2 of them have a population density over 150.00 per km square .
{'scope': 'subset', 'criterion': 'greater_than', 'value': '150.0', 'result': '2', 'col': '6', 'subset': {'col': '5', 'criterion': 'less_than', 'value': '10.0'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'land area ( km square )', '10.0'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; land area ( km square ) ; 10.0 }', 'tointer': 'select the rows whose land area ( km square ) record is less than 10.0 .'}, 'population density ( per km square )', '150.0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose land area ( km square ) record is less than 10.0 . among these rows , select the rows whose population density ( per km square ) record is greater than 150.0 .', 'tostr': 'filter_greater { filter_less { all_rows ; land area ( km square ) ; 10.0 } ; population density ( per km square ) ; 150.0 }'}], 'result': '2', 'ind': 2, 'tostr': 'count { filter_greater { filter_less { all_rows ; land area ( km square ) ; 10.0 } ; population density ( per km square ) ; 150.0 } }', 'tointer': 'select the rows whose land area ( km square ) record is less than 10.0 . among these rows , select the rows whose population density ( per km square ) record is greater than 150.0 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_greater { filter_less { all_rows ; land area ( km square ) ; 10.0 } ; population density ( per km square ) ; 150.0 } } ; 2 } = true', 'tointer': 'select the rows whose land area ( km square ) record is less than 10.0 . among these rows , select the rows whose population density ( per km square ) record is greater than 150.0 . the number of such rows is 2 .'}
eq { count { filter_greater { filter_less { all_rows ; land area ( km square ) ; 10.0 } ; population density ( per km square ) ; 150.0 } } ; 2 } = true
select the rows whose land area ( km square ) record is less than 10.0 . among these rows , select the rows whose population density ( per km square ) record is greater than 150.0 . the number of such rows is 2 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_greater_1': 'filter_greater', 'filter_less_0': 'filter_less', 'all_rows_5': 'all_rows', 'land area (km square)_6': 'land area ( km square )', '10.0_7': '10.0', 'population density (per km square)_8': 'population density ( per km square )', '150.0_9': '150.0', '2_10': '2'}
['name', 'population ( 2011 )', 'population ( 2006 )', 'change ( % )', 'land area ( km square )', 'population density ( per km square )']
[['air ronge', '1043', '1032', '1.1', '6.00', '173.8'], ['beauval', '756', '806', '- 6.2', '6.71', '112.6'], ['buffalo narrows', '1153', '1081', '6.7', '68.63', '16.8'], ['cumberland house', '772', '810', '- 4.7', '15.69', '49.2'], ['denare beach', '820', '785', '4.5', '5.84', '140.4'], ['green lake', '418', '361', '15.8', '121.92', '3.4'], ['île - à - la - crosse', '1365', '1341', '1.8', '23.84', '57.3'], ['la loche', '2611', '2348', '11.2', '15.59', '167.5'], ['pelican narrows', '790', '599', '31.9', '3.70', '213.3'], ['pinehouse', '978', '1076', '- 9.1', '6.84', '142.9'], ['sandy bay', '1233', '1175', '4.9', '14.85', '83.0']]