Please ensure that you include the result table as well as your SQL; List the details of any works of art (including the Artist who created the work) that have more than three copies recorded in the...

Please ensure that you include the result table as well as your SQL;

1. List the details of any works of art (including the Artist who created the work) that have more than three copies recorded in the database.


2. List the details of any work of art (including the Artist who created the work) that has a Surrealist style.


3. List the details of the works of art (including the Artist who created the work, and the acquisition and asking price details) currently held in the gallery (e., works of art that have not been sold).
   


4. List the sales for each customer (e., when a customer purchases a work of art from the Gallery, a transaction line is created. For a purchase, there will be values in the DateSold and SalesPrice columns).
   The query should include the details of the customer, the transaction and the work of art purchased.


5. 
   List the names of the deceased artists and the number of years of age they were when they died (for example, an artist born in 1950 and deceased in 2001 has an age of 51).