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? | Sololearn: Learn to code for FREE!

0

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?

Assistance needed please. Its urgent.

8/23/2020 3:35:08 PM

Chudyn

3 Answers

New 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.

0

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

0

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