1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE T_NOTATION_NTT
(NTT_INTERNAUTE VARCHAR(32),
NTT_VOTE INT)
INSERT INTO T_NOTATION_NTT VALUES (1, 3)
INSERT INTO T_NOTATION_NTT VALUES (2, 3)
INSERT INTO T_NOTATION_NTT VALUES (3, 4)
INSERT INTO T_NOTATION_NTT VALUES (4, 4)
INSERT INTO T_NOTATION_NTT VALUES (5, 4)
INSERT INTO T_NOTATION_NTT VALUES (6, 4)
INSERT INTO T_NOTATION_NTT VALUES (7, 5)
INSERT INTO T_NOTATION_NTT VALUES (8, 5)
INSERT INTO T_NOTATION_NTT VALUES (9, 5)
SELECT CAST(SUM(N * NTT_VOTE) AS FLOAT) /
CAST((SELECT COUNT(*)
FROM T_NOTATION_NTT) AS FLOAT) AS P
FROM (SELECT COUNT(*) AS N, NTT_VOTE
FROM T_NOTATION_NTT
GROUP BY NTT_VOTE) AS T |
Partager