Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using a numeric loop that runs from the first student id = 105 to the last student id=150, select student first_name, last_name and also how
Using a numeric loop that runs from the first student id = 105 to the last student id=150, select student first_name, last_name and also how many sections the student is enrolled into. Maximum number of sections a student is allowed to enroll into is 5. If student enrolled in less then 5 (use here your IF statement), then calculate how many more additional sections the student can enroll into, and display a message in the following format: John Johansen is enrolled in 3 sections and is eligible for 2 more Carrie Drew is enrolled in 2 sections and is eligible for 3 more We had a program in class designed with FOR loop for STUDENT table, making a list of students in a numeric FOR loop. If you missed the class, please watch the recordings, Week 3 A, to get the idea of how to implement EXCEPTION block in inner begin-end block for the program not to break on a missing student in the list
Step by Step Solution
There are 3 Steps involved in it
Step: 1
You may accomplish this in SQL by iterating through the student IDs and gathering the necessary data ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started