SQL home work help.

[imfrom51]

I am a newbie with sql and need some help.

Question Details:
ARTIST.Name
Artist.Nationality
Transaction.purchaseDate
Transaction.SalesPrice...
Customer.Name
Customer.Phone.AreaCose
Customer.Phone.LocalNumber
Customer.Name...

(The Ellipses(...) refer to the structures that can repeat.

Code SQL statements to update this view as follows:
a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby.
I have

Update     ARTIST
           Set         name = 'Mark Toby' 
           Where   name = 'Mark Tobey';

b. Create a new transaction for Mark Toby. Assume you have the necessary transaction, work, and customer data in a structure named NewTrans.

c. Add new interested customers for Mark Toby. Assume they are stored in a collection that you can access with the command For Each NewCust.Name?
I have:

SELECT  ARTIST.name 'Mark Toby'
       FROM       ARTIST
    WHERE     ARTIST.name = NewCust.ARTIST.name
    INSERT    INTO CUSTOMER_ARTIST_INT
                    (CustomerID, ArtistID)
                    VALUES (NewCust.CUSTOMER.Customer.ID, ARTIST.ArtistID)
    NEXT NewCust.ARTIST.Name

Thanks a bunch. let me know if you need more information.