Assignment #3: Write SQL code for the queries given below (in Access or other DB). Show your query and the results. Worth a maximum of 95 points.

Extra Credit: 10 points. Dump your access database out (5 points) and input into another database (5 pts). You can team up with another classmate to do this. For your result show the data in a different database.

Output should be printout. I may need access to your Access database to grade it, so please keep this available.

Queries:
1. make a sorted list of unigenes for species X. (Note whenever you see something "X", this means you need to make your query prompt for the value of that something, in this case of species).
2. find all unigenes in family X (i.e. prompt for family_id).
3. list go term, peptide sequence, species name and latin species name, and phtyome ID for a specific unigene.
4. make a sorted list of the count of the unigenes for each species.
5. list goID and unigene name of unigenes with GO terms containing the phrase "binding".