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.

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

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

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.

En el contexto de la gestión de bases de datos, ¿qué asegura la "integridad referencial"?

Considere las siguientes tablas para las preguntas 18-19

¿Cuál de las siguientes instrucciones devolverá el promedio del balance de los clientes agrupado por SalesRepNo?