Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sum(dco.prix_unitaire * dco.quantite) as Montant,
- sum(dco.prix_unitaire * dco.quantite) / (select sum(prix_unitaire * quantite)
- from details_commandes) *100 as pourcentage
- from details_commandes dco
- inner join commandes co ON dco.no_commande = co.no_commande
- inner join clients cl ON co.code_client = cl.code_client
- where cl.pays = 'Brésil';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement