Basic Queries - Records Insight (cnt logon, logoff, id...)

Part2

--all records: 17403
Select count(actionname) as allLogs
from puzzSessions;
--logOFF: 8687
Select count(ActionName) as cntLOFF
from puzzSessions
where ActionName='LOGOFF';
--logON: 8716
Select count(ActionName) as cntLOFF
from puzzSessions
where ActionName='LOGON';
--uniqueID=8717
Select count(distinct Session_ID) as allUniqueIDs
from puzzSessions;