Wrong expectation when count and join 3 table
<p>I have 3 tables: broadcasts, broadcasts_likes and broadcasts_viewers:</p>

<p><a href="https://i.stack.imgur.com/1YMxO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1YMxO.png" alt="enter image description here"></a></p>

<p>I want return result include total_likes, total_viewers but when I run this sql, the expectation is wrong, could you help me check this. I just want use sql normally, don't use sub query. Here is my sql: </p>

<pre><code>SELECT `b`.*, 
COUNT(`bl`.`broadcast_id`) AS `total_likes`,      
COUNT(`bv`.`broadcast_id`) AS `total_viewers` 
FROM `broadcasts` `b` 
LEFT JOIN `broadcasts_likes` `bl` 
ON `b`.`broadcast_id` = `bl`.`broadcast_id` 
LEFT JOIN `broadcasts_viewers` `bv` 
ON `b`.`broadcast_id` = `bv`.`broadcast_id` 
GROUP BY `b`.`broadcast_id`;
</code></pre>