SQL joins HW

My biggest problem is understanding the difference between the different joins (inner, left, etc) and when to utilize each.