Q8. For every artwork sold, list the artist code, artist full name, artwork title, the gallery name for the gallery in which the work was sold, the estimated minimum selling price, the sale price and the percentage that the artwork sold above the estimated minimum selling price. The estimated minimum selling price includes the commission payment to the gallery where it was sold, the commission payment to ACL and the minimum payment to the artist. For example, an artwork has been provided by an artist with an indicated minimum payment to the artist of $1,400.00. This artwork is to be sold by a gallery with a 10% commission. An estimate of the minimum selling price must include the minimum payment to the artist, the gallery commission and the ACL commission (20%). Here since 30% is commissions, the $1,400.00 must represent 70% of the sold price, thus the actual selling price would need to be at least $2,000.00 (artist payment $1,400.00, gallery commission $200.00 and MAU commission $400.00) ie. $2,000.00 is the minimum estimated sales price. The percentage is calculated based on the selling price and the estimated minimum selling price. As an example, assume an artwork which had an estimated minimum selling price of $2,000.00 sold for $2,500.00 - this would represent a sale at 25% above the minimum selling price. If the percentage has decimal digits, round it to the 1 decimal place. The output must be displayed in an ascending order of the percentage that the artwork sold above the estimated minimum selling price. Q8. For every artwork sold, list the artist code, artist full name, artwork title, the gallery name for the gallery in which the work was sold, the estimated minimum selling price, the sale price and the percentage that the artwork sold above the estimated minimum selling price. The estimated minimum selling price includes the commission payment to the gallery where it was sold, the commission payment to ACL and the minimum payment to the artist. For example, an artwork has been provided by an artist with an indicated minimum payment to the artist of $1,400.00. This artwork is to be sold by a gallery with a 10% commission. An estimate of the minimum selling price must include the minimum payment to the artist, the gallery commission and the ACL commission (20%). Here since 30% is commissions, the $1,400.00 must represent 70% of the sold price, thus the actual selling price would need to be at least $2,000.00 (artist payment $1,400.00, gallery commission $200.00 and MAU commission $400.00) ie. $2,000.00 is the minimum estimated sales price. The percentage is calculated based on the selling price and the estimated minimum selling price. As an example, assume an artwork which had an estimated minimum selling price of $2,000.00 sold for $2,500.00 - this would represent a sale at 25% above the minimum selling price. If the percentage has decimal digits, round it to the 1 decimal place. The output must be displayed in an ascending order of the percentage that the artwork sold above the estimated minimum selling price
