Mysql count with two joins

select
  t.Topic,
  t.Title,
  s.StarCount,
  m.UserCount,
  m.MessageCount
from
  Topics t
  left join (
    select 
      Topic, 
      count(distinct User) as UserCount,
      count(*) as MessageCount
    from Messages
    group by Topic
  ) m ON m.Topic = t.Topic
  left join (
    select
      Topic, 
      count(*) as StarCount
    from Stars_Given 
    group by Topic
  ) s ON s.Topic = t.Topic

Source: stackoverflow.com

Similar codes

15 votes343 views2 answers
Sql order by multiple columns
SQL
0 vote329 views1 answer
Check mysql password with docker container magento 2
SQL
16 votes377 views1 answer
Mssql int max value
SQL
0 vote342 views2 answers
Mysql to python pandas
SQL
0 vote402 views1 answer
Create table using the clause with as
SQL
1 vote337 views1 answer
Mysql show data from table
SQL
0 vote340 views1 answer
Gcloud check sql
SQL
1 vote354 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote373 views1 answer
Sql query tags
SQL
0 vote342 views1 answer
Kill thread
SQL