How to do these two questions inSQL

1. List each Advisor on the major table, and for each Advisor, list the first and last name of the students they advise. Only include students whose entry year is 2006 or 2007. Sort alphabetically by advisor, then the student last name and then the student first name.
2. Prepare a query to list the total credit hours for each department. Only include list those departments that have a total of 8 or more credit hours.

\begin{tabular}{l} Class \\ \hline CiassiD \\ CourselD \\ Semester \\ Ciasssection \\ instructor \\ tocation \\ Time \\ MaxEnroliment \\ \hline \end{tabular} USResident State MajoriD 00 \begin{tabular}{|l|l|l|l|l|} \hline & \multicolumn{1}{|c|}{ MajorID } & MajorDept & \multicolumn{1}{c|}{ Advisor } & Click to Add \\ \hline & ACC & Accountancy & Celia Havisham & \\ \hline ECO & Economics & John Cripe \\ \hline FIN & Finance & Lisa Goetz \\ \hline ISA & Info. Sys. \& Anal Kimberly Sullivan & \\ \hline MGT & Management & Chris Roeth \\ \hline MKT & Marketing & Tyler Wassel \\ \hline \end{tabular}