can you solve this by oracle live SQL

Lab Exercise Create the following tables and insert some values. STUDENT (STDNO, SNAME, DEPTNO\#) DEP (DEPTNO, DNAME) COURSE (CORSNO, CNAME, DEPTNOH, CMAX) ENROLMENT (STDNO\#, CORSNO\#, GRADE, EDATE) Query a single table 1) Display the whole content of the DEP table 2) Display all columns of the ' CP department 3) Display the whole content of the STUDENT table 4) Display STDNO and SNAME for students in department ' CP 7) Display all columns for departments when the Dname starts with letter ' M ' or ' C '. 8) Display all columns for courses sorting the result by the CMAX descending