Get user details using v2 call order by last visit time

Hi All,

I want users sorted by there last activity.

I have tried V2 call :

SELECT * FROM users WHERE roles.name="Administrator"

It have a last_visit_time as one parameter. Can we use this for getting result of users order by this parameter?

I have tried bellow call but it gives error.

SELECT * FROM users WHERE roles.name="Administrator" ORDER BY last_visit_time'

Please help me if you know any better approach or any thing that sorts users by last_visit_time.

Regards,

Mahesh Revanwar