mysql programming basic queries

I need help with writing these queries and check each one to make sure that they're the ones I'm looking for.