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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!