requetes.sql 371 Bytes
Newer Older
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
SELECT nomMolec as medicament, COUNT(nomMolec) as quantite_prescrit
FROM Posologie
WHERE idAnimal= $idAnimal
GROUP BY nomMolec;


SELECT COUNT (*) as quantite_medicament
FROM Posologie
WHERE nomMolect = $nomMolec;


SELECT AVG(poid) as Poids_Moyen
FROM Animal
WHERE especeNom = $especeNom;


SELECT AVG(taille) as Taille_Moyenne
FROM Animal
WHERE especeNom = $especeNom;