manonmauperrin

use wild_db_quest;
(1)
select wizard.lastname, wizard.firstname, player.roles, team.name
from wizard
join player
on player.wizard_id=wizard.id
join team
on player.team_id=team.id
ORDER BY team.name ASC, player.roles ASC, wizard.lastname ASC, wizard.firstname ASC;

manonmauperrin

SELECT * FROM wild_db_quest.player;
select name, count(*) as nb_player from team
join player 
on team.id = player.team_id
group by team_id
order by nb_player desc;

SELECT * FROM wild_db_quest.player;
select name, count(*) as nb_player from team
join player