VRG database manipulation 2 tables

VRG DATA - CUSTOMER 1

VRG DATA - CUSTOMER_ARTIST_INT 1

VRG DATA - ARTIST 1

VRG DATA - WORK 1

VRG DATA - TRANS 1

Provide SQL AND result tables for the following queries.

1. How much does VRG make from each artist? Suppose the acquisition price is the only investment

NEED HELP WRITING THE CODE FOR THIS ANSWER!!

2. List the work ID, title, description, sales price, and the first and last name of the artist for the most expensive and least expensive artwork.

NEED HELP WRITING THE CODE FOR THIS ANSWER!!

CUSTOMER i. CustomerID LastName FirstName EmailAddress (AK1.1) EncryptedPassword Street City State ZIPorPostalCode Country AreaCode PhoneNumber CUSTOMER_ARTIST_INT ArtistID CustomerID \begin{tabular}{|l|l|} \hline 17 & 1000 \\ \hline 18 & 1000 \\ \hline 19 & 1000 \\ \hline 1 & 1001 \\ \hline 2 & 1001 \\ \hline 4 & 1001 \\ \hline 5 & 1001 \\ \hline 11 & 1001 \\ \hline 11 & 1015 \\ \hline 17 & 1015 \\ \hline 18 & 1015 \\ \hline 19 & 1015 \\ \hline 17 & 1033 \\ \hline 18 & 1033 \\ \hline 19 & 1033 \\ \hline 1 & 1034 \\ \hline 2 & 1034 \\ \hline 4 & 1034 \\ \hline 5 & 1034 \\ \hline 5 & 1036 \\ \hline 11 & 1036 \\ \hline 19 & 1036 \\ \hline 17 & 1040 \\ \hline 18 & 1040 \\ \hline 19 & 1040 \\ \hline 17 & 1051 \\ \hline 18 & 1051 \\ \hline 19 & 1051 \\ \hline H1WLL & \\ \hline \end{tabular} CUSTOMER_ARTIST_INT 1 ARTIST 1 TransactionID DateAcquired AcquisitionPrice AskingPrice DateSold SalesPrice CustomerID WorkID \begin{tabular}{|l|l|l|} \hline FirstName & LastName & Profit \\ \hline Joan & Miro & 225.00 \\ Wassily & Kandinsky & 25.00 \\ Paul & Klee & il. \\ Henri & Matisse & 475.00 \\ Marc & Chagall & 300.00 \\ John Singer & Sargent & 250.00 \\ Mark & Tobey & 12625.00 \\ Paul & Horiuchi & 65150.00 \\ Morris & Graves & 20250.00 \end{tabular} \begin{tabular}{|lll|lll} WORKID & title & Description & PRICE & LastName & FirstName \\ \hline 500 & Memories IV & 3124.8 in. & 72500.00 & Horiuchi & Paul \\ 523 & On White II & Bauhaus style of Kandinsky & 200.00 & Kandinsky & Wassily \\ 551 & Der Blaue Reiter & The Blue Rider-Early Pointilism influence & 200.00 & Kandinsky & Wassily \\ 521 & The Tilled Field & Early Surrealist style & 200.00 & Miro & Joan \end{tabular}