Hello! I have an issue regarding a UNIVERSITY database made in MySQL$.$

The following is the command used to create said database $($minus the populated info$).$

create database university$\_$COP$4703\_1248$;

use university$\_$COP$4703\_1248$;

CREATE TABLE COLLEGE$($

CName varchar$(200)$PRIMARY KEY,

COffice varchar$(50),$

CPhone varchar$(20),$

Dean varchar$(10)$NOT NULL

$)$;

$/*$This is the table for departments$*/$

CREATE TABLE DEPARTMENT$($

DCode varchar$(100)$PRIMARY KEY,

DName varchar$(100)$NOT NULL UNIQUE,

DPhone varchar$(20),$

DOffice varchar$(50),$

Chair varchar$(10)$NOT NULL,

CStartDate datetime NOT NULL,

College varchar$(200)$NOT NULL,

FOREIGN KEY $($College$)$REFERENCES COLLEGE$($CName$)$ON UPDATE CASCADE

$)$;

CREATE TABLE COURSE $($

CoCode varchar$(10)$PRIMARY KEY,

CoName varchar$(100)$UNIQUE NOT NULL,

CoLevel ENUM$(\text{'}$Freshman$\text{'},$'Sophomore','Junior','Senior','Grad',$\text{'}$PhD$\text{'})$NOT NULL,

CDesc varchar$(300),$

Credits INTEGER DEFAULT $0,$

Department varchar$(100)$NOT NULL,

FOREIGN KEY $($Department$)$REFERENCES DEPARTMENT $($DCode$)$ON UPDATE CASCADE

$)$;

CREATE TABLE INSTRUCTOR $($

Id varchar$(10)$PRIMARY KEY,

IName varchar$(100)$NOT NULL,

IPhone varchar$(20),$

IOffice varchar$(50),$

IRank ENUM$(\text{'}$Adjunct$\text{'},$'Faculty','Tenure'$)$NOT NULL,

Salary FLOAT,

Department varchar$(100)$NOT NULL,

FOREIGN KEY $($Department$)$REFERENCES DEPARTMENT$($DCode$)$ON UPDATE CASCADE

$)$;

ALTER TABLE COLLEGE ADD CONSTRAINT FOREIGN KEY $($Dean$)$REFERENCES INSTRUCTOR $($Id$)$ON

UPDATE CASCADE;

ALTER TABLE DEPARTMENT ADD CONSTRAINT FOREIGN KEY $($Chair$)$REFERENCES INSTRUCTOR

$($Id$)$ON UPDATE CASCADE;

CREATE TABLE SEMESTER $($

SCode char$(4)$PRIMARY KEY,

SName varchar$(20)$NOT NULL,

Start$\_$Date datetime NOT NULL,

End$\_$Date datetime NOT NULL

$)$;

CREATE TABLE PREREQUISITE $($

Course varchar$(10),$

Prerequisite varchar$(10),$

PRIMARY KEY $($Course$,$Prerequisite$),$

FOREIGN KEY $($Course$)$REFERENCES COURSE $($CoCode$)$ON UPDATE CASCADE,

FOREIGN KEY $($Prerequisite$)$REFERENCES COURSE $($CoCode$)$ON UPDATE

CASCADE

$)$;

CREATE TABLE STUDENT $($

Sid varchar$(10),$

FName varchar$(100)$NOT NULL,

LName varchar$(100)$NOT NULL,

MName varchar$(100),$

Addr varchar$(200),$

Major varchar$(200),$

Phone varchar$(20),$

DoB datetime NOT NULL,

GPA float $,$

Department varchar$(100)$NOT NULL,

PRIMARY KEY$($Sid$),$

FOREIGN KEY $($Department$)$REFERENCES DEPARTMENT$($DCode$)$ON UPDATE CASCADE

$)$;

CREATE TABLE SECTION $($

Course varchar$(10),$

SectID varchar$(10),$

Sect$\_$Schedule varchar$(50),$

CRoom varchar$(10),$

Instructor varchar$(10)$NOT NULL,

Semester char$(4)$NOT NULL,

PRIMARY KEY $($Course$,$SectID$),$

FOREIGN KEY $($Course$)$REFERENCES COURSE $($CoCode$)$ON UPDATE CASCADE,

FOREIGN KEY $($Instructor$)$REFERENCES INSTRUCTOR$($Id$)$ON UPDATE CASCADE,

FOREIGN KEY$($Semester$)$REFERENCES SEMESTER$($SCode$)$ON UPDATE CASCADE

$)$;

CREATE TABLE ENROLLMENT$($

Student varchar$(10),$

Course varchar$(10),$

SectID varchar$(10),$

Points float,

Letter$\_$Grade ENUM$(\text{'}$A$\text{'},\text{'}$B$\text{'},\text{'}$C$\text{'},\text{'}$D$\text{'},\text{'}$F$\text{'}),$

PRIMARY KEY $($Student$,$Course,SectID$),$

FOREIGN KEY$($Course$,$SectID$)$REFERENCES SECTION$($Course$,$SectID$),$

FOREIGN KEY $($Student$)$REFERENCES STUDENT $($SId$)$

$)$;

While there is no info inside the database yet, I was hoping anyone could help me with executing a command in order to filter out data.

$1.$ Write and execute an SQL statement to retrieve the name of students who have been enrolled in any section associated to course with code 'HTA$-2241\text{'}$

$2.$ Write and execute an SQL statement to retrieve the name of departments that have instructors with salaries between $$90,000$ and $$110,000.$

Any help would be greatly appreciated, thank you!