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 vote226 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote231 views1 answer
Group by sql not ordering issues
SQL
0 vote231 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote223 views2 answers
How to enable error squiggles in vs code
SQL
0 vote253 views1 answer
"Hello User Name"
SQL
0 vote236 views1 answer
Into operator in sql
SQL
0 vote230 views1 answer
Mysql error 1251
SQL
0 vote230 views1 answer
Sqlite version check
SQL
1 vote245 views1 answer
Update foreign key value in mysql
SQL
0 vote214 views1 answer
Sql change default collation to utf8
SQL