Instructions
Read the following and write the SQL that would provide the data to answer the question. Remember that inserting a donor involves several seperate inserts. Turn in the SQL. You do not need to turn in the results of the query.
1.Insert the following new donor and his donation:
Jonathan Sanderson 1200 East Meridian Seattle, WA, 98001 Home phone: 206-555-0303 Cell phone: 206-555-1112 email: desertsands@gmail.com donation amount: $500.00 donation date: 5/2/2010
3. Add an apartment number "203" to the address with the address key 46
4. Change the first name from "Mike" to "Micheal" for personkey 16.
5. Change the address for Alysson McGraw to "1120 19th Avenue, Kent, 98012" Change her home phone number to 425-555-0047
5. Remove "Funerary" from Services
6. Remove Fax from Contact Type