Please post the table schemas in your q here, as part of the q. That is, post the CREATE TABLE statements for the tables. Then we can write queries to answer your two qs. And walk you through how we created the queries the way we did.
Just so you'll know for the future, it's considered polite to post the schema when asking for query help. I don't have time to go download that db to recreate the schema; I would think most other people here wouldn't have time to do that either.