Advertisement
Guest User

Untitled

a guest
Oct 24th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. select sum(dco.prix_unitaire * dco.quantite) as Montant,
  2. sum(dco.prix_unitaire * dco.quantite) / (select sum(prix_unitaire * quantite)
  3. from details_commandes) *100 as pourcentage
  4. from details_commandes dco
  5. inner join commandes co ON dco.no_commande = co.no_commande
  6. inner join clients cl ON co.code_client = cl.code_client
  7. where cl.pays = 'Brésil';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement