Please ensure that you include the result table as well as your SQL; you can copy and paste this from either your ssh client or SQL Developer. These tables exist in arion and are owned by the user...

Please ensure that you include the result table as well as your SQL; you can copy and paste this from either your ssh client or SQL Developer. These tables exist in arion and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own account. If you do so, you should ensure that you copy the sample data in dtoohey’s tables.

These queries are based on the View Ridge Gallery database you have been using in the Lab sessions. Please see Chapters 6 and 7 of Kroenke for background to the case and table structures.

1. The sum of the acquisition price of works of art for each year (for example, if there were two works of art purchased for $1500 and $1000 in 2019, and one work of art purchased for $500 in 2020, then the sums would be $2500 and $500, for 2019 and 2020 respectively).


2. Which artist has had the most works of art sold, and how many of the artist’s works have been sold?