How to sort the views by a column from a custom database table?

Question

I have a custom database table my_apps.

This table has nid and uid columns.

I have created a view, which is displaying some nodes. I want to sort this view from that custom table.

Like ORDER BY COUNT(uid from my_apps) where nid={nid from my_apps}

Is this possible?

I tried this module Views custom table but then you have to create the view based on that table instead of a content view. And I don't want that.