s' il vous plait professeur cette requete me renvoi qu elle ne se termine pas bien je sais pas ou se situe le probleme
1.)Les formations (description, prix, …)ayant le minimum de participants
select descfrom,prix,count(CodForm)
from(select count(CodForm)
from inscription i
group by codpart) as a join formation f on f.Codform=a.codform
having count(codpart)<(select max(count(codpart))
from inscription i
group by Codpart);
Entre autres, l'écriture max(count(codpart)) est invalide
select f.codform, descfrom, prix , count(Codpart)
from formation f join inscription i on f.Codform=i.codform
group by f.codform, descfrom, prix ,
having count(codpart) = ( select max (nbp)
from ( select count(codpart) as nbp
from inscription
group by Codform
)
)