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

$\backslash$table$[[\backslash$table$[[$sql$>$select $*$ from students;$],[$student$\_$id $|$ name$]],|$ surname $||$ department,$\backslash$table$[[$sql$>$ select $*$ from grades;$],[$student$\_$id $|$ course$\_$code $|$ grade$]]],[20201||$ John,$|$ Cash,$|$ CENG,$20186||$ CS$3003,86],[20193||$ Mark,$|$ Twish,$|$ EENG,$20207||$ CS$3003,75],[20186||$ Mary,$|$ Hall,$|$ CENG,$20201||$ CS$3003,81],[20198||$ Jule,$|$ Carter,$|$ EENG,$20198||$ CS$3003,90],[20207||$ Martin,$|$ Hary,$|$ CENG,$20198||$ CS$3001,86],[20195||$ Lorry,$|$ Bond,$|$ CENG,$20195||$ CS$3003,74],[20192||$ Jane,$|$ York,$|$ EENG,$20192||$ CS$3001,67],[,,,20193||$ CS$3001,83],[,,,20192||$ CS$3003,79]]$

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

a$)$

$\backslash$table$[[$CENG $4,$b$)$

$\backslash$table$[[$CS$300178\mathrm{.}66],[$EENG $3]],],[,$CS$300380\mathrm{.}83,],[,,]]$

c$)$

$\backslash$table$[[$CS$30018667],[$CS$30039074],[]]$

d$)$

$201922$

$201982$

e$)$

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

$\backslash$table$[[$a$),],[$b$),],[$c$),],[$d$),],[$e$),]]$

Note: Please post handwritten solutions to the online system in a well$-$format single PDF document.