I'm trying to get an sql where I can see the elapsed time(Hours, minutes) for a user that hasn't done any activity. Any suggestions?
I have the following tables
Table test, datareg = the time for the latest activity by a user
and the result would be something like this