Two questions about SQL based on an ERD diagram. (novice level)

I've attached a picture that shows the ERD diagram that these two questions apply to.

The ERD is about optometry doctors and their patients. It's basically coursework but I'm having trouble understanding these two.

Any good SQL savvy people out there willing to help me out with the corresponding SQL statements? Thank you. This is the ERD

1. A list of the patient’s name and the doctor who currently treats that patient, the date of the last eyetype result, the last glasses type and its brand, now show all these patients that also live either Chicago or San Diego. Also order by date and inside that on patient’s name

2. A list that shows per each brand of glasses the total count of every patient that wears the corresponding brand. Show only the results where the total amount of patients is more than 25.