Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 $college 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 $college We'll be using the same interview student table from the previous question, and a new tabe interview account old Both edeta e eo . 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 I Student ID | Last Name | College | GPA l 463127376 I willemsen | A l 2.37 | Imore data.. ll interview-account-hold . I Student_TD I Amount Due | 1416996983 | 3,403.28 1287856417 | 2,318.13 | 537713123 | 3,678.86 ...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