Hi,

Add  "GROUP BY a.analytic_account_id" at the end after your "WHERE " condition

SELECT a.analytic_account_id AS x_analytic_account_id, SUM(a.credit - a.debit) AS x_sale
FROM account_move_line AS a
JOIN account_account AS b ON a.account_id = b.id\\\
JOIN account_account_type AS c ON b.user_type_id = c.id
WHERE c.name = 'Income' AND a.parent_state ='posted'
GROUP BY a.analytic_account_id

In  newer  versions  of  pgadmin  using postgresql , every column which you are viewing need to be in group by clause

Thanks