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

Draw a table containing the following information for at least 10 U.S. states:

• The name of the state.
• The year the state entered the Union.
• The latest population estimate.
• The approximate area in miles².

The entire table should have a name, and each column should also have a name.

Write five questions about the data in the table, and then, for each question, write a syntactically correct SQL statement to answer it. Collectively, the statements should

• Use at least three different relational operators. (>, <, etc.)
• Include arithmetic computation. (Addition, subtraction, etc.)
• Show only columns of interest.

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