Write a procedure STUDENTS_BY_STATUS (status VARCHAR(10)) that accepts a status

Question

  Write a procedure STUDENTS_BY_STATUS (status VARCHAR(10)) that accepts a status like: "Freshman", "Sophomore", “Junior” or "Senior" and when called displays the BannerId’s and names of all students with that status. Copy and paste the code for the procedure below. Test your procedure by executing these calls.

CALL STUDENTS_BY_STATUS("Freshman");

CALL STUDENTS_BY_STATUS("Sophomore");

CALL STUDENTS_BY_STATUS( "Junior");

CALL STUDENTS_BY_STATUS("Senior");

Here are the tables:

Tables are bellow:

Student Table

Department Table

Professor Table

Course Table

Teaching_Assignment Table:

Transcript Table:

Banner Id 100 101 102 103 104 105 106 107 108 109 110 Name Leona Jerald Freddie Shannon Billie Casey Nicole Alex Mona Anthony Thomas Curtis Addres Status Freshman Freshman Freshman Sophomore Sophomore Sophomore Junior Junior Junior Senior Senior Senior

Explanation / Answer

Select Name from student where Status ='Freshman';

Select Name from student where Status='Sophomore';

Select Name from student where Status='junior';

Select Name from student where Status='senior';

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.