Question: in sql developer Bonus Question: Create a list of all sections that indicates how many places are available in each section (i.e. capacity - #

in sql developer
Bonus Question: Create a list of all sections that indicates how many places are available in each section (i.e. capacity - \# of students enrolled). Use decode to display a message of "Filled" if there are no more places; " \# places available" (as in "10 places available) if capacity has not yet been reached but some are enrolled; and "None enrolled" if no one has enrolled. Use TO_CHAR to convert numbers to strings when needed. Use an outer join to include all the sections. (78 rows) COURSE_NQ SECTIQN_NO Places Available
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
