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
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
