Answering 2 MYSQL questions

I need help answering two SQL questions. You need to provide a solution AND EXPLAIN how the code works.

Needs to be done by end of today (These questions will be very simple for SQL experts).