Mysql select and count left join

select
  t.Topic,
  t.Title,
  count(distinct s.starID) as StarCount,
  count(distinct m.User) as UserCount,
  count(distinct m.messageID) as MessageCount
from
  Topics t
  left join Messages m ON m.Topic = t.Topic
  left join Stars_Given s ON s.Topic = t.Topic
group by
  t.Topic,
  t.Title

Source: stackoverflow.com

Similar codes

0 vote326 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote344 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote332 views1 answer
How to use lower case in mysql
SQL
2 votes347 views2 answers
How to run postgresql in linux
SQL
13 votes350 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote284 views1 answer
Into sql
SQL
1 vote323 views1 answer
Stop mysql server mac
SQL
-1 vote367 views3 answers
PS5
SQL
15 votes321 views2 answers
How to drop database name in postgresql
SQL
0 vote325 views1 answer
Complete date is 1 year or not sql server
SQL