Hey! Can someone please help me? I have to write SQL queries using subqueries and set operators.

This is the information i have to use:

College(cName text, state text, enr int);

Student(sID int, sName text, GPA real, HS int);

Apply(sID int, cName text, major text, decision text);

1. Names of the biggest colleges by enrollment (must use not exists)

2. Pairs of colleges in same state (no self- or reverse- parings)

3. List of college and student names

4. Names that are both a college name and a student name

Thanks in advance! Any notes would help as well if you can.