At this point I am just trying to get it to work in arcgis pro. I was able to get the bottom 1100 scores using definition query SQL :
[field] IN (SELECT TOP 1100 [field] FROM [layer] order BY [field])
The problem now is that I want the order reversed. I want to pick the top. Is there a way to reverse the order?