Glad you figured out the query. As far as making an admin column sortable, you’re going to need to find the information on that somewhere else. There are several tutorials and code examples available https://www.google.com/search?q=wordpress+make+admin+column+sortable&ie=utf-8&oe=utf-8
