用于从日志表计算访问持续时间的SQL查询

I have a MySQL table LOGIN_LOG with fields ID, PLAYER, TIMESTAMP and ACTION. ACTION can be either 'login' or 'logout'. Only around 20% of the logins have an accompanying logout row. For those that do, I want to calculate the average duration.I have a MySQL table LOGIN_LOG with fields ID,