Homework 1
CS122, Spring 2004

Due: Thursday, April 15

Please send the solutions to csun@calstatela.edu by email. Make sure to use CS122 Spring 04 HW1 as the subject of the email, and include in the email your name so I don't have to guess names from email addresses.

---

0. Read  Chapter 1 and 2 of the textbook.

Use Movies.mdb for the following problems:

1. (5pt)  List the movies that grossed more than $1M this weekend and more than $50M overall. Sort the results first in overall gross and then weekend gross.

2. (5pt) List the movies distributed by SONY, WB or MGM which have grossed between $10M and $50M overall. The results should show title, distributor, and overall gross ordered first by distributor then by overall gross.

3. (5pt) List the movie titles which contain the word THE. Note that THE must appear as a word in the title, e.g. Godfathers or Their does not count.

4. (5pt) List the movies with single-word titles.

5. (5pt) List the movies with multiple-word titles and the first word in the title has exactly 5 letters.

6. (5pt) List the titles that are not distributed by SONY or WB.