Requete Sql avec date du jour automatique!

SELECT DISTINCT  GETDATE() - 90),at.num_at, at.Date_at, T.code_type, at.nom_at, at.prenom_at, C.nom_centre, UP.nom_up, UEP.nom_uep, AT.Nom_Equipe, M.nom_manager
FROM [at], TypeBless AS T, Managers AS M, Centre AS C, UP, UEP, Actions AS A
WHERE (((T.num_type)=[AT].[num_type])
AND ((M.num_manager)=[AT].[num_manager]) 
AND ((C.num_centre)=[AT].[num_centre]) 
AND ((UP.num_up)=[AT].[num_up]) 
AND [AT].num_at=((A.num_at)) 
AND ((UEP.num_uep)=[AT].[num_uep])) 
AND nom_centre ='PMT'
And Realise Is null

SELECT DISTINCT  at.num_at, at.Date_at, T.code_type, at.nom_at, at.prenom_at, C.nom_centre, UP.nom_up, UEP.nom_uep, AT.Nom_Equipe, M.nom_manager
FROM [at], TypeBless AS T, Managers AS M, Centre AS C, UP, UEP, Actions AS A
WHERE (((T.num_type)=[AT].[num_type])
AND ((M.num_manager)=[AT].[num_manager]) 
AND ((C.num_centre)=[AT].[num_centre]) 
AND ((UP.num_up)=[AT].[num_up]) 
AND [AT].num_at=((A.num_at)) 
AND ((UEP.num_uep)=[AT].[num_uep])) 
AND nom_centre ='PMT'
And Realise Is null
and at.date_at in (Select (GETDATE() - 90) from at);

SELECT DISTINCT  at.num_at, at.Date_at, T.code_type, at.nom_at, at.prenom_at, C.nom_centre, UP.nom_up, UEP.nom_uep, AT.Nom_Equipe, M.nom_manager
FROM [at], TypeBless AS T, Managers AS M, Centre AS C, UP, UEP, Actions AS A
WHERE (((T.num_type)=[AT].[num_type])
AND ((M.num_manager)=[AT].[num_manager]) 
AND ((C.num_centre)=[AT].[num_centre]) 
AND ((UP.num_up)=[AT].[num_up]) 
AND [AT].num_at=((A.num_at)) 
AND ((UEP.num_uep)=[AT].[num_uep])) 
AND nom_centre ='PMT'
And Realise Is null
and at.date_at  >= (GETDATE() - 90);