Question: function is a little different from description and has to be solved in this format.

 function is a little different from description and has to be

function is a little different from description and has to be solved in this format.

function hasHold($college)

{

{

string hasHold string Scollege In a hypothetical scenario, the accounting office has provided us a list of students who currently have holds on their accounts because of unpaid tuition. They are only listed by ID and amount due; and they are only listed if they have an amount due. Students who have no amount due are not listed Your task is to write a function named hasHold that takes a string Scollege and returns a MySQL query which returns the Student_ID, Last_Name, College, and Amount_Due for all students which have accounts on hold in the $Scollege. We'll be using the same interview_student table from the previous question, and a new table interview_account_hold. Both are detailed below. Remember to select the columns in the order Student_ID, Last_Name, College, Amount_Due. And once again, you do not need to handle the actual connection, executing the query, parsing the results, etc. Just return your query as a string | interview_student | Student_ID I Last Name College | GPA I 463127376 I Willemsen I A | 2.37| | .. more data I interview_account hold I Student_TD I Amount Due | 416996983 3,403.20 | 287856417 | 2,318.13 I |537713123 3,678.06 I I more data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!