Concernant l'extraction, faites comme ceci :


select mat_tr
, sum(MT_brut)
, sum(retenu)
from Travailleurs
where ma_date between '2016-01-01' and '2016-12-31'
group by mat_TR