When do you plan on posting the DDL of the tables for the top 4 queries along with keys indexes and sample data. You already gave the rowcount, but did you do it for all tables?

The contest is pretty much useless without that. We can't post tested code bassed on your need so at this point this is just a guess!