Question: can someone please help me write the necessary executable codes as per the comments that i recieved because I'm struggling and i am directionless as



lATE for aedect " from Coutanaponetiptioni select - Iron Coufanapetrog2021/ select cho, ereditin from Cout ainabe acerlpecan where prerequinite is not nelit sistact Aotitit keno) FRoe Couraembencut ption where eno like "ciel": aeleot etn,tho, atatzaken from Courvealipritiga21 OADeR by mo DEsc; seot Taken asc; (-.1) melect cno, anatiahen 0.5 more eno dike 'enel', por exorple, 'asollo', (0,5) neloct cno, seatcapnoity teom couroosspringzoz1 Need to whe a subquen to help. axtrer mimattaken Naced T declare a function (1) 1:10at5Gcu insert into CoursesSpring2021 values ('10000', 'mat307', '24', '18'); select * from CoursesDescription; select * from Coursesspring2021; seleat cno, credits from Coursespescription where prerequisite i,8 not null; gELBCT COUNT (cno) FROM CoursesDescription where cno like 'cscs'; welect crn, cno, seattaken frrom Coursesspring2021 ORDER bY cno DESC; seat Taken asc; whase erscie" circis 904 other courses may also be ofered by csc department, whara cno itka 'enel': for example, 'asollo', (0.5) (1) 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 prerequisite 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 CoursesSpring2021 where no like 'csc % '; \{other courses may also be offered by csc department for example' assolo'\} select cno. seatCanacitv from 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 lATE for aedect " from Coutanaponetiptioni select - Iron Coufanapetrog2021/ select cho, ereditin from Cout ainabe acerlpecan where prerequinite is not nelit sistact Aotitit keno) FRoe Couraembencut ption where eno like "ciel": aeleot etn,tho, atatzaken from Courvealipritiga21 OADeR by mo DEsc; seot Taken asc; (-.1) melect cno, anatiahen 0.5 more eno dike 'enel', por exorple, 'asollo', (0,5) neloct cno, seatcapnoity teom couroosspringzoz1 Need to whe a subquen to help. axtrer mimattaken Naced T declare a function (1) 1:10at5Gcu insert into CoursesSpring2021 values ('10000', 'mat307', '24', '18'); select * from CoursesDescription; select * from Coursesspring2021; seleat cno, credits from Coursespescription where prerequisite i,8 not null; gELBCT COUNT (cno) FROM CoursesDescription where cno like 'cscs'; welect crn, cno, seattaken frrom Coursesspring2021 ORDER bY cno DESC; seat Taken asc; whase erscie" circis 904 other courses may also be ofered by csc department, whara cno itka 'enel': for example, 'asollo', (0.5) (1) 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 prerequisite 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 CoursesSpring2021 where no like 'csc % '; \{other courses may also be offered by csc department for example' assolo'\} select cno. seatCanacitv from 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
