1- Give the SQL code to insert the cNames of the colleges from the College table into CollegeStat along with the appCount,minGPA and maxGPA.

2- Give the SQL code to increase the enrollment of all colleges except WSU by 1000.

I would like to get help with these questions and thank you for your help.

Y IN sid 234 345 345 345 345 543 678 678 678 765 876 876 876 987 987 cName major decision U of O biology IN Cornell bioengineering N Cornell CS Cornell EE MIT bioengineering Y MIT CS IN Cornell history N Cornell psychology WSU history WSU history MIT biology MIT marine biology N WSU CS WSU CS U of 0 CS TY IY cName state enrollment U of O OR WSU WA 25000 28000 NULL NULL NULL sid sName GPA sizeHS 345 456 543 567 654 678 1765 789 876 987 NULL Craig 3.5 Doris 3.9 Craig 3.4 Edward 2.9 Amy 3.9 Fay 3.8 Jay 2.9 Gary_ 3.4 Irene 3.9 Helen 14 NULL NULL 500 1000 2000 2000 1000 200 1500 800 400 800 NULL cName major min GPA WSU CS 3.75 WSU EE 3.5 WSU history 2.8 U of 0 CS 3.6 U of O biology 3.75 Cornell bioengineering 3.8 Cornell CS 3.4 Cornell EE 3.6 Cornell history 3.6 Cornell psychology 2.8 MIT biology 3.5 MIT bioengineering 3.5 MIT CS 3.9 MIT marine biology 3.5 major bioengineering biology CS EE history marine biology psychology NULL