Please Help write SQL queries for these questions:

1. List the part_ID of all participants who volunteered. For each participant also also list the first date they volunteered and how long they volunteered on that date (participant who have not volunteered yet will not appear in your output). Use a correlated subquery.

2. For the courses BRA, CBB, and TAT, list the course_number, number of sessions for the course, as well as the session ID and enrollment number (use a Windows Function)

3. Create a Teaching Table. It has the following columns: teach_ID is the primary key and has datatype NUMBER (6), part_ID is the foreign key that links to the participant table, course_number is the foreign key that links to the course table, teaching_certificationDate has the Date type. Also write the corresponding DROP statement for the table teaching.

4. Create an index on course session room number

5. List the course numbers and numbers of sessions for each course. Include only courses with more than 5 sessions. Use a WITH clause.