i'm not the best sql wizard out there, but assuming boardStyle is the column name and jsp is using mysql (dark mode has a value of 7, regular mode is 0)
they'd have to execute something like this to get your answer
Code
SELECT
boardStyle,
COUNT(*) * 100.0 / (SELECT COUNT(*) FROM users) AS percentage
FROM
users
GROUP BY
boardStyle;
also, other dark styles would be d2jsp Dark Chrome (5), d2jsp Black/Orange (18), [Dark Gray] - LostPeon (16), [Black/Red] - Juggalo_Mole (13) and so on
so you'd have to factor in those as well in the final percentage
This post was edited by ChocolateCoveredGummyBears on Jun 1 2024 06:57am