I have 3 tables like so

Table 1: UserInfo

```
user_id   userName   

```

```
123       userOne  

```

Table 2: Post

```
user_id   postContent   

```

```
123       This is test message  

```

Table 3: LikePost

```
user_id   likesPostId   

```

```
123       This is test message  

```

I would like to run a query to get total number of post likes, posts, and user information from those 3 tables.

I can do this for each one such as in Post table: 

```
SELECT COUNT(*) FROM Post WHERE Post.user_id = '123'

```

and `SELECT * FROM UserInfo WHERE UserInfo.user_id = '123'`

Is anyone have better solution in just 1 query? Thank you so much!