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

0 vote219 views1 answer
Frename oracle
SQL
1 vote244 views1 answer
Postgresql can you have null foreign key
SQL
0 vote168 views2 answers
Avg() sql
SQL
1 vote199 views1 answer
Mysql select row max date
SQL
0 vote203 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
1 vote200 views2 answers
Laravel get sql query eloquent with parameters
SQL
4 votes186 views2 answers
Truncate oracle
SQL
3 votes253 views1 answer
How to uninstall microsoft sql server
SQL
1 vote198 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote158 views1 answer
Update set with join pl sql
SQL