Question $3.(15$ points$)-$ DELETE

The university has decided to cancel INST$326$ for the Fall $2024$ semester $.$ You need to remove

all course sections of INST$326$ for Fall $2024($use the course$\_$sections$\_$copy table$).$ First, write a

SELECT query that replicates the result set below $($column headers do not need to match

exactly$).$ This query is to help you determine which rows need to be removed from the

course$\_$sections$\_$copy table. Please order by semester and year in descending order but any

additional ordering is not necessary as your output does not need to exactly match.

Then, write a DELETE query. To make sure the values are properly deleted, include the same

SELECT query you wrote above to check that the values were removed by the DELETE. Again.

you must include the SELECT query before and after the DELETE. The results of the SELECT

after the DELETE are included below:

$4$ rows returned.