Skip to content

Pourcentage de navigateur dans les connexions utilisateur

1
2
3
4
5
6
7
SELECT 
    browser,
    COUNT(*) AS total_count,
    (COUNT(*) * 100.0 / (SELECT COUNT(*) FROM user_login WHERE created_at LIKE '2023-%')) AS percentage
FROM user_login
WHERE created_at LIKE '2023-%'
GROUP BY browser;

Keywords

count navigator percentage user_login statistics