ELECT a.matr
,[nom]
,[prn]
,cast([dat_nais] as date) as dat_nais
, (YEAR(getdate()) - YEAR(dat_nais)) as age
,cast([dat_deces] as date) as dat_deces
,cast([dat_imm] as date) as dat_imm
,cast([dat_aj] as date) as dat_j
,[cod_position]
,YEAR(dat_imm) as anne_imm
,YEAR(dat_encais) as ann_regl
,[annee]
,[cod_nat]
,cast([dat_e
Snc] as date) as dat_regl
,[mt_encais]
FROM users a
left join enca e on e.matr = a.matr
left join encr c on (c.cod_encais = e.cod_encais)
where (YEAR(c.dat_enc) - c.annee > 3 ) and ((YEAR(getdate()) - YEAR(a.dat_nais)) between 54 and 70) and c.cod_nat = 'CN'
order by a.nom_, a.prn, c.annee asc;
who can i performe this query using django ORM, note that i'm using MSSQL; thank very much