Dons

SELECT
	acc_transactions_users.id_user AS 'Reçu',
	users.id AS 'idPers',
	users.nom AS 'Nom',
	printf('%.2f', SUM(acc_transactions_lines.credit)/100.) AS 'Montant',
	users.adresse AS 'Adresse',
	users.code_postal AS 'Code postal',
	users.ville AS 'Ville'
FROM
	acc_transactions_users
	INNER JOIN users ON acc_transactions_users.id_user = users.id
	INNER JOIN acc_transactions ON acc_transactions_users.id_transaction = acc_transactions.id
	INNER JOIN acc_transactions_lines ON acc_transactions_lines.id_transaction = acc_transactions.id
WHERE strftime('%Y', acc_transactions.date) =  strftime('%Y',  DATE('now', '-1 year'))
GROUP BY users.id
ORDER BY users.nom COLLATE NOCASE