SQL GROUP BY Homework Assignment
Chum 240 Fall 2007
Due date: (see schedule)

Given the table below

misspell
word	part	errors
beginning	n	21
beginning	v	21
refer	v	5
receive	v	10
gray	adj	5
etc.

Do the following tasks with SQL statements

1. Count the number of words in the table.
2. Count the number of verbs.
3. List just the words in descending order.
4. Report the number of words for each part of speech.
5. Report the number of errors for each part of speech sorted by error count.
6. Words that are more than one part of speech and how many parts they are.

For each part show the statement statement and typical results.

Download the database from http://humanities.byu.edu/chum/classes/chum240/group-hw.zip and make sure your queries work.

Your assignment should have a cover sheet with the class (CHum 240 Sec. 001), your name, and the date the assignment is due.

Copyright ©2007 Brigham Young University