sum specific values in table postgres

Question

So I am new to postgres and having some issues, this is my table:

I would like a query to return the table in this format:

I would like the area to be distinct with the sum of all sales in area1 and for area2, any help is appreciated.

Answer 1

You need GROUP BY

SELECT
  Area,
  SUM(sales) AS "sales"
FROM myTable
GROUP BY area
ORDER BY area;