Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

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

New Trends In Databases And Information Systems Adbis 2019 Short Papers Workshops Bbigap Qauca Sembdm Simpda M2p Madeisd And Doctoral Consortium Bled Slovenia September 8 11 2019 Proceedings

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Robert Wrembel ,Mirjana Ivanovic ,Johann Gamper ,Mikolaj Morzy ,Theodoros Tzouramanis ,Jerome Darmont

1st Edition

3030302776, 978-3030302771

More Books

Students also viewed these Databases questions

Question

Presentation Aids Practicing Your Speech?

Answered: 1 week ago