I did all the ones I could, but had trouble coming up with like the last 6 of the SQL statements required. So, I put what the database looks like, and the problems I couldn't figure out into Word....

some of the things in there seem to require more than 1 query, such as the first one, and the last one. what version of mysql are you doing this on? 4.1 supports subqueries, but 4.0 doesn't. do ...