Using the PSQL function in a linux terminal solve.

PART1

Provide solutions with screenshots please show everything. I will like pls solve

Part 1: Relational Algebra Queries The queries in this section will be based on the following relational schema: Student (SID, given name, surname, username, major) Enrolled (SID, OID, grade) Offering(IOID, course_code, year, term, duration) Course (course code, description, department, weight) PreReq (enrolled course, required course, min_grade) Here is a subset of a typical student database schema which would record student enrollment. A course is the generic description of a course which is offered by a department, the prereq relation indicates what courses are prerequisites for other courses. The offering relation is the specific instance of a course being taught in a given term, and is the entity which will be associated with the student enrollment. 1. Write a query which will list the course_code, year, term, duration and grade for all the courses taken by the student with SID "1357246". 2. Write a query which will list the SID, given_name and surname of the students who achieved a grade of 95% or greater in the 2022 school year. 3. Write a query which will list the full student record for any student who has never registered in a course. 4. Write a query which will list the surnames of the students who are enrolled in both "COSC 2P13" and "COSC 3P32" in the Winter 2023 term (2022 FW 03). 5. Write a query which will list the SID of any student in the Winter (2022 FW 03) offering of COSC3P32 who does not have the proper prerequisites for the course. 6. Write a query which will list the SID and surname of the student(s) who have taken all of the courses associated with the "Computer Science" department. 7. Write a query which will list the full name and the grade of the students who received one of the two highest marks in "COSC3P32" for the school year 2022 (two distinctly different marks, so there may be more than 2 studetns listed)