$3.$ Consider the following tables. $(10$ pts $)$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{3\}\{|$l$|\}\{\backslash$begin$\{$tabular$\}\{$l$\}$

sql$>$select $*$ from students; $\backslash \backslash$

student$\_$id$|$ name $|$ surname $|$ department

$\backslash$end$\{$tabular$\}\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{\backslash [$

$\backslash$begin$\{$array$\}\{$l$\}$

$\backslash$hline $\backslash$text $\{$ sql$>$ select $*$ from grades; $\}\backslash \backslash$

$\backslash$text $\{$ student$\_$id $|$ course$\_$code $|$ grade $\}$

$\backslash$end$\{$array$\}$

$\backslash ]\}\backslash \backslash$

$\backslash$hline $20201|$ John & $|$ Cash & $|$ CENG & $20186|$ CS$3003$ & $86\backslash \backslash$

$\backslash$hline $20193|$ Mark & $|$ Twish & $|$ EENG & $20207|$ CS$3003$ & $75\backslash \backslash$

$\backslash$hline $20186|$ Mary & $|$ Hall & $|$ CENG & $20201|$ CS$3003$ & $81\backslash \backslash$

$\backslash$hline $20198|$ Jule & $|$ Carter & $|$ EENG & $20198|$ CS$3003$ & $90\backslash \backslash$

$\backslash$hline $20207|$ Martin & $|$ Hary & $|$ CENG & $20198|$ CS$3001$ & $86\backslash \backslash$

$\backslash$hline $20195|$ Lorry & $|$ Bond & $|$ CENG & $20195|$ CS$3003$ & $74\backslash \backslash$

$\backslash$hline $20192|$ Jane & $|$ York & $|$ EENG & $20192|$ CS$3001$ & $67\backslash \backslash$

$\backslash$hline & & & $20193|$ CS$3001$ & $83\backslash \backslash$

$\backslash$hline & & & $20192|$ CS$3003$ & $79\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Write the smallest SQL that will produce EXACTLY the following output using the table above:

a$)$

$\backslash$begin$\{$tabular$\}\{|$l$|\}$

$\backslash$hline CENG $4\backslash \backslash$

EENG $3\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

b$)$

$\backslash$begin$\{$tabular$\}\{|$l$|\}$

$\backslash$hline CS$300178\mathrm{.}66\backslash \backslash$

CS$300380\mathrm{.}83\backslash \backslash$

$\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

c$)$

$\backslash$begin$\{$tabular$\}\{|$l$|\}$

$\backslash$hline CS$30018667\backslash \backslash$

CS$30039074\backslash \backslash$

$\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

d$)$

$\backslash$begin$\{$tabular$\}\{|$l$|\}$

$20192\backslash \backslash$

$20198\backslash \backslash$

$2$

$\backslash$end$\{$tabular$\}$

e$)$ EENG CS$300178\mathrm{.}6$

EENG CS$300384\mathrm{.}5$ CENG CS$300379\mathrm{.}0$

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|\}$

$\backslash$hline b$)$ & $\backslash \backslash$

c$)$ & $\backslash \backslash$

$\backslash$hline d$)$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$