79576852

Date: 2025-04-16 09:44:09
Score: 1.5
Natty:
Report link

Something like (code not tested) :

SELECT      c.Firstname,
            c.LastName,
            count(*) as the_count
FROM    Users c
JOIN    ViewedPlayers p ON p.CreatedByCharacterID = c.ID
GROUP BY c.Firstname, c.LastName
ORDER BY count(*) DESC
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Aurette