How to use an SQL statement to calculate the number of Logon times for each user from the logon log table?

How to use an SQL statement to calculate the number of Logon times for each user from the logon log table?

This is definitely a basic skill, and there is no reason to say no, or even don't know, As a question you have been thinking about.

SQL:

SELECT user_name, COUNT (*) as countFROM logGROUP BY user_name

If HAVING is added, it is used as the condition query Control for count quantity,

For example, HAVING count> 1 indicates the number of users who log on more than once and the corresponding number of logins.