SQL Server Automatic Update

Question

I have several online registered users in my web application but only less than 20% of them uses the system. 

 

My question is, how to query in SQL Server that will automatically update the value from active to inactive if the last login of the user is 3 months ago or none at all?

 

Thanks for your help.