Paste Search Dynamic
Recent pastes
Benefice
  1. create table Benefice(
  2. Commande_id INT not null,
  3. prix_vente FLOAT,
  4. prix_achat FLOAT,
  5. foreign key (Commande_id) references Commandes(id)
  6. foreign key (Prix_vente) references Commandes(Prix_vente)
  7. foreign key (prix_achat) references Produits(prix_achat)
  8. );
  9. b)
  10. select SUM(Prix_vente) from Commandes
Parsed in 0.001 seconds