Calculate the total profit made on all the works of art that have been sold (the profit/loss on a work of art is the difference between the acquisition price and the sales price)

List the work ID, title and artist name of all the works of art that sold for more than the average price of all sales, and the price they sold for. (use subquery)

List all the artist and the number of unique works.

List the full name of each artist represented in the database and the number of works of art by that artist, for those artists that have more than four (4) works of art in the gallery.

List the names of customers and the sum of sales prices for their transactions, considering only transactions with a sales price exceeding $500.

List the details of any work of art (including the name of the artist who created the work and the acquisition and asking price details) currently held in the gallery (i.e. works of art that have not been sold) with an asking price of > $400.

Use vrg database to answer the following questions

List the full details of any work of art,

including the name of the artist who created the work, that have been described

as Surrealist.

Esta es la vista de diseño de la tabla GRADE.

¿Cuál es la clave primaria de la tabla GRADE?

¿Cuál de las siguientes instrucciones en SQL devolvería solo el nombre del representante de ventas y el nombre del cliente para cada cliente que tenga un saldo mayor a 400?

¿Qué implica la integridad de dominio en una base de datos?