Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
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