b$-$ Specify the following queries in SQL on the database schema of Figure $1.4$ Marks$)$

Retrieve the names of all senior students majoring in 'COSC' $($computer science$).$

Retrieve the names of all courses taught by professor King in $85$ and $86.$

For each section taught by professor King, retrieve the course number, semester, year, and number of students who took the section.

STUDENT

$\backslash$table$[[$Name$,$Student$\_$number,Class,Major$],[$Smith$,17,1,$CS$],[$Brown$,8,2,$CS$]]$

COURSE

$\backslash$table$[[$Course$\_$name,Course$\_$number,Credi$\_\_$hours,Dopartment$],[$Intro to Computer Science,CS$1310,4,$CS$],[$Data Structures,CS$3320,4,$CS$],[$Discrete Mathomatics,MATH$2410,3,$MATH$],[$Database$,$CS$3380,3,$CS$]]$

SECTION

$\backslash$table$[[$Soction$\_$idontifier,Course$\_$number,Semester,Year,Instructor$],[85,$MATH$2410,$Fall,$07,$King$],[92,$CS$1310,$Fall,$07,$Anderson$],[102,$CS$3320,$Spring,$08,$Knuth$],[112,$MATH$2410,$Fall,$08,$Chang$],[119,$CS$1310,$Fall,$08,$Andorson$],[135,$CS$3380,$Fall,$08,$Stone$]]$

GRADE REPORT

$\backslash$table$[[$Studont number,Section$\_$identrior,Grade$],[17,112,$B$],[17,110,$C$],[8,85,$A$],[8,92,$A$],[8,102,$B$],[8,135,$A$]]$

PREREQUISITE

$\backslash$table$[[$Course$\_$number,Prerequisite number$],[$CS$3380,$CS$3320],[CS3380,$MATH$2410],[CS3320,$CS$1310]]$

Figure $1.$