I am trying to find the users who have the highest "Following vs. Friends" ratio in my Twitter timeline.
I have a SQLite database of the users in my Twitter timeline and each column contains data found in the
user section of the tweet JSON.
Is there a better way that I could write this search query?
Why does it return zero when the user has a higher friends count than followers count?
Is there a way to shorten this search query?
SELECT CAST(followers_count AS DECIMAL)/ CAST(friends_count AS DECIMAL), screen_name FROM following ORDER BY CAST( CAST(followers_count AS DECIMAL)/ CAST(friends_count AS DECIMAL) AS INT) DESC LIMIT 25;