can someone please help me make the necessary changes as per the comments that's written in red and the comment that's inside {___} box. thank you, also make sure you post the output too

i just want to update the sql code as per the comments that's written in red and the one that's inside of { } box

lATE for The changes that needs to be made in second images are written with { brackets select * from CoursesDescription; select * from CoursesSpring2021; select cno,credits from CoursesDescription where prequisite is not null; SELECT COUNT (cno) FROM CoursesDescription where co like 'csc % '; select crn, cno, seattaken from CoursesSpring 2021 ORDER by cno DESC; (seat taken asc) select cno, seattaken from CoursesSpring2021 where cno='csc190'. \{Need to use min( () function and also groub by clause SELECT sum (seattaken) from CoursesSpring 2021 where no like ' csc% '; \{other courses may also be offered by csc department for example' assolo' select cno. seatCanacitv from select cno, seatCapacity from CoursesSpring 2021 where cno like 181 SELECT sum (seattaken) /5 from CoursesSpring2021 where cno like - 1% ' need to declare a function\} lATE for The changes that needs to be made in second images are written with { brackets select * from CoursesDescription; select * from CoursesSpring2021; select cno,credits from CoursesDescription where prequisite is not null; SELECT COUNT (cno) FROM CoursesDescription where co like 'csc % '; select crn, cno, seattaken from CoursesSpring 2021 ORDER by cno DESC; (seat taken asc) select cno, seattaken from CoursesSpring2021 where cno='csc190'. \{Need to use min( () function and also groub by clause SELECT sum (seattaken) from CoursesSpring 2021 where no like ' csc% '; \{other courses may also be offered by csc department for example' assolo' select cno. seatCanacitv from select cno, seatCapacity from CoursesSpring 2021 where cno like 181 SELECT sum (seattaken) /5 from CoursesSpring2021 where cno like - 1% ' need to declare a function\}