Suppose that there are three relationships in a database:

Student relationship: S(SNO, SNAME, AGE, GENDER, DEPT)

Enroll relationship: SC(SNO, CNO, GRADE)

Course relationship: C(CNO, CNAME)

Here, the abbreviation and their full name correspond as:

SNO	Student Id number	DEPT	Student department
SNAME	Student name	CNO	Course number
AGE	Student age	GRADE	Course grade for certain student
GENDER	Student gender	CNAME	Course name

Please read the questions carefully and write the following queries in T-SQL format (No need to execute each query). The 8^th questions relational algebra is provided as an example.

a) Query the id number and the grade of the students who enrolled the course whose course number is C2.

b) Query the id number and the name of the students who enrolled the course whose course number is C2.

c) Query the id number and the name of the students who enrolled the course whose name is SQL and NoSQL.

d) Query the id number of the student who enrolled C2 or C4 course.

e) Query the id number of the students who at least enrolled C2 and C4 courses.

f) Query the id number, name, and age of the students who did not enroll C2 course.

g) Query the names of the students who enrolled all of the courses.

h) Query all of the id number and name of the students who enrolled the courses that were also enrolled by student whose id number is S3.

_SNO,CNO (SC)% _CNO ( _SNO='S3 (SC))

i) Query all of the id number, name, gender, and department of the students who did not enroll in Network Admin w TCP/IP course.

j) Query all of the id number and name of the male students whose grade is 80-90 in the course of SQL and NoSQL.