sql programming

Hello i am looking for help with my assignments in unit 2 and also unit 3. i need help understanding and mastering these assignments