SQL statement SUM YEAR

How to write the SQL query?

The sum of the acquisition price of book for each year (for example, if there were two books purchased for $600 and $200 in 2022, and one books purchased for $250 in 2028, then the sums would be $800 and $250, for 2022 and 2028 respectively).

Source: sql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.