Given the tables below, write the following sal statements. $(10$ points$)$

student table

$\backslash$table$[[$studentID$,$studentFirstName,studentLastName,Major,advisorlD$],[1111,$Polly,Ester,Biology,$7890],[2222,$Holly,Trees,Accounting,$23456],[3333,$Dont,Know,Biology,$7890],[4444,$Olive,Oil,Accounting,$23456]]$

Advisor Table

$\backslash$table$[[$advisorID$,$facultyLastName,facultyFirstName,facRank,department$],[23456,$Adrian,Professor,accounting,$],[7890,$Monk,Inspector,Professor,Biology$],[,,,,]]$

a$)$ an SQL statement to display the student's name and their major sorted by student last Name and major.

b$)$ an SQL statement to display the faculty name, rank, and department, of the advisor the student with id $4444.$