IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL CONTACT
----- --------------- --------------- ---------- -- ----- --------- --------- ------------
11111 Stephen Daniels 123 Elm St Seekonk MA 02345 03-JUL-98 500 John Smith
12121 Jennifer Ames 24 Benefit St Providence RI 02045 24-MAY-97 400 Susan Jones
22222 Carl Hersey 24 Benefit St Providence RI 02045 03-JAN-98 Susan Jones
23456 Susan Ash 21 Main St Fall River MA 02720 04-MAR-92 100 Amy Costa
33333 Nancy Taylor 26 Oak St Fall River MA 02720 04-MAR-92 50 John Adams
34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa
 
Create a donor table that will hold the above data.
 

Pick appropriate sizes and data types (integer, varchar, char, date, datetime, float, text, decimal).

Do the following queries. You should take pictures of the screen showing the database, its description, the queries and the results of the queries.

1. Create a query to display the unique or distinct contacts from the donor table that you just created.
2. Create a query that displays 5 fields from the donor table and give each field an alias/column header.
3. Create a query to sort by yrgoal in descending order.
4. Create a query to concatenate the street address so you print stadr followed by a comma and a space and then city followed by a comma and a space and then state followed by a space and then zip.
5. Create a query to sort by datefst within state.
6. Create a query to display all contacts that have a Jo in their name.
7. Create a query to display all names where the first name starts with letters in the J-R range. Use the BETWEEN clause.
8. Create a query to display all donors that live in Providence, Seekonk or Swansea. Use the IN clause.
9. Create a query to display all people that gave their first contribution in 92.
10. Create a query to list all donors who have Susan Jones or John Adams as their contact person and display them in the order of name within city within state.