Need to write a query that returns the total profit made from 1Q of 2011- 4Q of 2016 in PgAdmin(sql). How do i go about this?

Question

Assistance needed please. Its urgent.

Answer 1

Without further detail of your table structure, it is difficult to give more specific advice. Posting your own attempt and explaining how it is not working, would ve helpful too.

Answer 2

Use "GROUP BY".
https://www.postgresqltutorial.com/postgresql-group-by/

Answer 3

Tibor Santa Thanks. I tried that but not working. Don't know if it should be done quarterly but cant run the query.