We have three table   

table 1- app ( id , name )   

table 2- appPlayer ( id , name )  

table 3- appPlayerSession ( id , appId , appPlayerId , version)

**my Current query is:** 

```
SELECT  (select name from app k where k.id= aps.appId) AS appName,version,appId,count(version) FROM appPlayerSession aps GROUP BY appId,version,appName

```

we need to count the session users for each game with same version, and also woth the object of all users data using single mysql query. 

Current Result using my query, but we also need players for each app..

[![enter image description here](https://i.stack.imgur.com/4XKDC.png)](https://i.stack.imgur.com/4XKDC.png)