[MySQL-5.6] Opérations Arithmétiques Sql

Bonjour,

J'aimerai si c'est possible de faire ce genre d'opérations en SQL?

J'ai actuellement ces reqûetes :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
SELECT SUM(affeng) FROM
(
	SELECT count(a.id)  as affeng
		FROM affaire a
		inner JOIN evenement e ON a.id = e.affaire_id and e.type_principal_id = 444
                                                                AND e.sous_type_id =477
                                                                AND e.date_creation between  DATE_SUB(NOW(),INTERVAL 1 YEAR) and NOW()
 
		WHERE
		a.client_id  in (86261) and a.segment_marche_id != 31
		UNION ALL
		SELECT count(a.id)  as affclot
		FROM affaire a
		inner JOIN evenement e ON a.id = e.affaire_id and e.type_principal_id = 444
                                                                AND e.sous_type_id =479
                                                                AND e.jalon_motif_id =441
                                                                AND e.date_creation between  DATE_SUB(NOW(),INTERVAL 1 YEAR) and NOW()
 
		WHERE
		a.client_id  in (86261) AND a.segment_marche_id != 31
) AS tmp;

et en fait en résultat final j''aimerai pouvoir avoir cette opération : (affeng / affeng + affclot) *100 afin d'avoir un pourcentage est ce possible?

Cordialement

SELECT 100.0 * COUNT(a.id) / (COUNT(a.id) + (SELECT count(a.id) as affclot FROM affaire AS a INNER JOIN evenement AS e ON a.id = e.affaire_id WHERE e.type_principal_id = 444 AND e.sous_type_id =479 AND e.jalon_motif_id =441 AND e.date_creation BETWEEN DATE_SUB(NOW(),INTERVAL 1 YEAR) AND NOW() AND a.client_id = 86261 AND a.segment_marche_id <> 31)) FROM affaire as a INNER JOIN evenement as e ON a.id = e.affaire_id WHERE e.type_principal_id = 444 AND e.sous_type_id = 477 AND e.date_creation BETWEEN DATE_SUB(NOW(),INTERVAL 1 YEAR) AND NOW() AND a.client_id = 86261 AND a.segment_marche_id <> 31;