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 vote118 views1 answer
Export mysql table to file
SQL
0 vote122 views1 answer
Sql cheetsheet
SQL
6 votes117 views2 answers
Mysql get yesterday
SQL
3 votes117 views2 answers
Df to sql pandas sql achemy
SQL
10 votes129 views2 answers
What is database
SQL
3 votes122 views2 answers
Sql get month name
SQL
0 vote112 views1 answer
Concatenate columns in table
SQL
0 vote119 views1 answer
Copy value from one column to another postgres
SQL
2 votes113 views1 answer
Mysql query unique column
SQL
0 vote110 views1 answer
Mysql function variable
SQL