Explain in English what the result of the following Query re

Explain in English what the result of the following Query represents:

SELECT Student _ID, Payment_Due_Amt
FROM Tuition _And_Fee_Tbl
WHERE Payment_Due-Amt > 0
AND (Actual _Return_Dt is NULL)
OR (Actual _Return_Dt > Scheduled _Return_Dt)
ORDER BY Payment _Due_Amt Desc;

Solution

To display records of student_id,Payment_Due_Amt column from Tution And fee table

those Payment_Due_amt is greater than zero AND Actual_Return_Dt is Null

OR Actual _Return_Dt is greater than Scheduled_Return _Dt

display these records using the column Payment _Due _Amt in a descending order

Explain in English what the result of the following Query represents: SELECT Student _ID, Payment_Due_Amt FROM Tuition _And_Fee_Tbl WHERE Payment_Due-Amt > 0

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site