ID First Name Last Name Year Subject Final Grade

$1$ John Smith $1$ IS $90$

$2$ Joana Adams $3$ AG BUS $87$

$3$ Alice Green $4$ Marketing $86$

$4$ Bob Sutton $2$ IS $92$

$5$ Jesus Hernandez $1$ Inerntaional Business $79$

$6$ Maria Khamos $3$ IS $95$

$7$ Joseph Tan $1$ Marketing $84$

$8$ Steve Robinson $1$ AG BUS $80$

$9$ Tom Aben $4$ Hospitality $78$

$1-$ What is the avergae grade for all students

$2-$ what is the number of students with grade $85$ or less

$3-$ What is the average grade for IS students

$4--$ What is the maximum grade of marekting students

$5-$ What is the grade percentrank of a student in year $2$ and last name is "Sutton"

$6-$ What is the average grade of students with first name starting with an $"$S$"$