Question: 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

1 Expert Approved Answer
Step: 1 Unlock

You may accomplish this in SQL by iterating through the student IDs and gathering the necessary data ... View full answer

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!