1. Write and run the SQL to list the different expected graduation dates [class of 20XX] in the BSU_Students table. List each expected graduation date only once.
2. Write a single SQL query using the BSU_Students table that will return a table, which shows the average SAT math scores and exclude the students whose major information is missing
3. Write a single SQL query using the BSU_StudentSchedule table that will return a table, which shows students that have completed course Acct23020. Sort the table by student id and semester.
4. Count the number of students in the BSU_Students table with a last name ending in r

BSU Classrooms 1 ClassroomID BuildingName ProjectorAvailable Capacity 18 18 BSU_Class 1 ClassID Credits ClassroomID ClassDescription StartTime EndTime Schedule Code BSU_StudentSchedule Classi Studenti Semester ClassStatus FinalGrade - BSU Students 1 Studenti StuFirstName StulastName StuAddress StuCity StuState StuZipCode StuEmail StuSATMath StuSATVerbal StuTotalCredit Hrs GPA StuMajori StuStart Date StuExpectedGradDate 00 BSU_Major Majorld MajDescription Credit HoursRea