LinkedIn Interview Question

How can you improve the linkedIn feed? Doing rank functions in SQL