drop view Historique_Aout;

create view Historique_Aout
(Identifiant_Client,Nom_Client,Aout_HT,Aout_TTC)
as select 
f.Identifiant_Client,
f.Nom_Client,
f.Prix_HT,
f.Prix_TTC
from Facture f
	where to_char(f.Date_Commande,'MM')= '08'
	order by f.Identifiant_Client; 