Please help. Need to write the awl statements for oracle. I will upvote clear response. Thanks

join, outer join Let us assume you have following comands to create two tables and have then populated with a couple records. create table students ssn varchar2 (10) primary key, name varchar2(20) insert into student values ('111', tester') insert into student values 222', 'tester2'): insert into student values 333 'tester2'): create table course ssn varchar 2020), insert into course values (111', 'CSC1242): insert into course values ('111 CSC1203" insert into course values 222 CSC1203 insert into course values 'CSC1204'); a. If a student takes a course, list the student' s ssn nane and the course name, if a student takes multiple courses, multiple records should be listed. the result should look like the following write a SQL command to find out the ansver, COURSEID CSC1242 tester CSC1203 tester tester 2 CSC1203 b. In addition to the above result, if a student exists in the student table but does not take any courses, we also want it to be listed in the result just leave courseid field blank, write a SQL command to find out the answer. ss tester COURSE ID CSC1242 CSC1203 tester CSC1203 tester/2 tester 2 b. We want to list all course names in the following table regardless it is registered by any student or not. If it is registered by multiple students listed, if a course in the course table is not registered by any people, the course still needs to be listed simply with ssr multiple record s need to d to the following result