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

2 votes124 views1 answer
Set boolean flasksql
SQL
0 vote120 views1 answer
Mysql workbench not showing schemas
SQL
1 vote113 views2 answers
Drop function in sql
SQL
0 vote135 views2 answers
How to drop mili second in sql
SQL
0 vote159 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote114 views1 answer
Inner join distinct
SQL
0 vote107 views1 answer
Mysql database is not starting in xampp
SQL
0 vote121 views1 answer
Drop-toys-table
SQL
11 votes109 views2 answers
Having clause
SQL
4 votes120 views1 answer
T-sql get duplicate rows
SQL