Google Sheets SORT FILTER nested formula, sorting by multiple columns and filtering by multiple conditions (AND logic)

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.