How to fetch Player record from table in sql?

Question

I have Three tables as,

Player Table,

- id
- name
- team_id

Team Table:

- id
- image
- tournament_id

Tournaments Table:

- id
- name

and I want to fetch count of employee appearing in Tournaments. Thanks

question from:https://stackoverflow.com/questions/65931323/how-to-fetch-player-record-from-table-in-sql

Answer 1

I want to fetch count of employee appearing in Tournaments.

This can be achieved using JOIN and group by as follows:

select t.id, t.name, count(*)
  from tournaments t
  join team tm on t.id = tm.tournament_id
  join player p on p.team_id = tm.id
 group by t.id, t.name