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

1 vote326 views1 answer
Oracle lowercase
SQL
-1 vote330 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote309 views1 answer
Big query add table rows to another table
SQL
1 vote362 views1 answer
Sql order by where condition
SQL
6 votes356 views3 answers
Update with inner join postgres
SQL
1 vote343 views1 answer
Set statiscis on in ssms
SQL
0 vote407 views1 answer
Min varias colunas spark sql
SQL
50 votes408 views4 answers
Sql alter type of column
SQL
2 votes353 views2 answers
Sql strip non alphanumeric characters
SQL
1 vote341 views2 answers
Mysql extract month
SQL