Show session count opened per each user

This will show only user ID:

select userid, count(*) from sessions group by userid order by count(*) desc limit 10;

The fix is by using this syntax:

SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Solution:

SELECT sessions.userid,users.alias,count(*)
FROM sessions
INNER JOIN users ON sessions.userid = users.userid
GROUP BY sessions.userid;