-------------- SELECT COUNT(*) FROM coursFC WHERE titre LIKE "% C%" -------------- +----------+ | COUNT(*) | +----------+ | 2 | +----------+ 1 row in set (0.00 sec) -------------- SELECT COUNT(*) FROM coursFC,partiFC WHERE idcours=numcours AND session=1 -------------- +----------+ | COUNT(*) | +----------+ | 24 | +----------+ 1 row in set (0.00 sec) -------------- SELECT titre, niveau FROM coursFC LEFT JOIN partiFC ON idcours=numcours WHERE numcours IS NULL -------------- +--------------------+--------+ | titre | niveau | +--------------------+--------+ | Initiation Ruby | 1 | | Programmation Java | 1 | | Programmation Java | 2 | | Initiation Rexx | 1 | +--------------------+--------+ 4 rows in set (0.01 sec) -------------- SELECT nomparti, c1.titre FROM partiFC, coursFC c1, coursFC c2 WHERE c1.idcours=numcours AND c1.titre=c2.titre AND c1.niveau=1 AND c2.niveau=2 -------------- +---------------+-----------------+ | nomparti | titre | +---------------+-----------------+ | Zelig | Initiation Perl | | Massenat | Initiation Perl | | Kentynne | Initiation Perl | | Sensodune | Initiation Perl | | Temperince | Initiation Perl | | Ritintin | Initiation Perl | | Dupont | Programmation C | | Martin | Programmation C | | Durand | Programmation C | | Valrejan | Programmation C | | Bounette | Programmation C | | Callouin | Programmation C | | Smith | Programmation C | | Sabotageur | Programmation C | | Sabrinajel | Programmation C | | Rabougret | Programmation C | | Lelievre | Programmation C | | Parker | Programmation C | | Jaroud | Programmation C | | Valha | Programmation C | | Danieljocksan | Programmation C | | Abygibbs | Programmation C | | Dinozarella | Programmation C | | Meredith | Programmation C | +---------------+-----------------+ 24 rows in set (0.00 sec) -------------- SELECT c1.titre, COUNT(c1.titre) AS Effectif FROM partiFC, coursFC c1, coursFC c2 WHERE c1.idcours=numcours AND c1.titre=c2.titre AND c1.niveau=1 AND c2.niveau=2 GROUP BY c1.titre ORDER BY Effectif DESC -------------- +-----------------+----------+ | titre | Effectif | +-----------------+----------+ | Programmation C | 18 | | Initiation Perl | 6 | +-----------------+----------+ 2 rows in set (0.00 sec) Bye