Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Process Driven Database Design With Oracle PL SQL

Authors: Rajeev Kaula

1st Edition

1795532386, 978-1795532389

More Books

Students also viewed these Databases questions