need help with this query in sql.

here are the tables

students(sid,name,age,gpa) // sid is the primary key

courses(cid,deptid, description) // cid,deptid is the primary key

professors(ssn,name,address,phone,deptid) // ssn is the primary key

enrollment(sid,cid,section,grade) cid makes reference to the courses table. // sid, cid, and section is the primary key

teaches(cid,section,ssn). cid, section makes reference to the enrollment table // cid, section is the primary key

Assume that small sections have less than 30 students, medium sections have at least 30 students but less than 80, and large sections have at least 80 students.

Write a query that produces the following table:

deptid	small	medium	large
cs
math
...	...	...	...