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 vote229 views1 answer
Join to find results not in another table
SQL
1 vote195 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
3 votes251 views2 answers
Find string in stored procedure sql server
SQL
2 votes187 views1 answer
While loop sql
SQL
0 vote255 views1 answer
Sql commands in android
SQL
0 vote217 views1 answer
Unique element in sql
SQL
2 votes236 views1 answer
Postgresql format date dd/mm/yyyy
SQL
1 vote208 views1 answer
Mysql select for update ejemplo
SQL
0 vote198 views1 answer
Mysql Like(searching in the string)
SQL
0 vote208 views1 answer
Dataframe lambda elif
SQL