Would someone please assist in writing some SQL code for the attached entity relationship diagram? Below you will find what is needed for the code:

3.SQL Data Queries. For 3.1 through 3.7, write the SQL query AND show the output using the data in your base tables.

Write a SQL query using a comparison operator (e.g., =, >,

Write a SQL query using the AND or OR operator.

Write a SQL query using the BETWEEN or LIKE operator.

Write a SQL query using a built-in function.

Write a SQL query using the GROUP BY clause.

Write a SQL join query using two or more base tables.

Write a SQL subquery using two or more base tables.

Marksheet (PK) Student ID Semester Has Professor (PK) Professor ID Professor Name Professor Sex Professor DOB Professor Address Professor Join Date Professor Designation Professor Salary Head of Department (PK) HOD ID HOD Department HOD Name HOD Sex Years of Experience Contact Number Department (PK) (FK) Department ID Department Name NUMBERREGISTERED Student (PK) Enroll Number (PK) (FK) Student ID (FK) Department ID Student Name Student DOB Student Address Student Sex Contact Number Tea Belongs Cordinate Fees (PK) Student ID (FK) Course ID Payment Method Instructs Principal (PK) Principal ID Principal Name Principal Join Date Principal Salary Enrolled For COURSE (PK) Course ID Course Name Course Fees