posted 11 years ago
Hi,
could any member tell me how could I figure out the next query.
In my DDBB I have a field "numbers of times the user has used the system", country, username, userId and timesAccessed(sessionId). I am tying to figure out the next:
Details on the 10 users who more times have accessed to the system, split out by country.
For example:
Select username, userId from Users ORDER BY MAX(count(sessionId)) DESC LIMIT 10 where country="US";
Do you think this query makes any sense?
Many Thanks,