Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Development For Dummies

Authors: Allen G. Taylor

1st Edition

978-0764507526

Students also viewed these Databases questions

Question

Did you add the logo at correct size and proportion?

Answered: 1 week ago

Question

Did you ask for action?

Answered: 1 week ago