power.html

1. {5:SAC:=SELECT} `{5:SAC:=supplier}`.`{5:SAC:=name}`, COUNT(`{5:SAC:=machine}`.`{5:SAC:=id}`), COUNT(DISTINCT `{5:SAC:=maintenance}`.`{5:SAC:=id}`))
2. {5:SAC:=FROM} `{5:SAC:=supplier}`
3. JOIN `machine` ON `{5:SAC:=supplier}`.`id` = `{5:SAC:=machine}`.`{5:SAC:=id_supplier}`
4. JOIN `maintenance` ON `{5:SAC:=machine}`.`id` = `{5:SAC:=maintenance}`.`{5:SAC:=id_machine}`
5. GROUP BY `{5:SAC:=supplier}`.`{5:SAC:=id}` ;