Fastest way to sort on multiple count?

[eddy_turbox (Edgar H)]

Thank you so much for the fast response @Prasad_Saya !

Regarding indexes, does it affect performance much having a compound index for sorting and another one for filtering/matching?