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

Query the following in T-SQL format:

1. Query all of the id number, name, gender, and department of the students who did not enroll in Network Admin w TCP/IP course.
2. Query all of the id number and name of the male students whose grade is 80-90 in the course of SQL and NoSQL.