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 vote182 views1 answer
Syntax for changing column size in mysql
SQL
0 vote192 views1 answer
C# get sql min date
SQL
0 vote176 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote253 views1 answer
Pgsql sum switch case
SQL
2 votes187 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote226 views1 answer
SQL SERVER xquery count child nodes
SQL
17 votes247 views6 answers
Sql current date
SQL
1 vote184 views2 answers
Postgresql list columns
SQL
11 votes189 views2 answers
MySQL DISTINCT
SQL
0 vote182 views1 answer
T-sql update table variale
SQL