Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Query to use to ans the question below: SELECT hsp.GUARANTOR_ID Guarantor ID ,SUM(hsp.TOT_ACC_BAL) Sum of HAR Balances FROM HSP_ACCOUNT hsp INNER JOIN ACCOUNT guar ON
Query to use to ans the question below:
SELECT
hsp.GUARANTOR_ID "Guarantor ID" ,SUM(hsp.TOT_ACC_BAL) "Sum of HAR Balances" FROM HSP_ACCOUNT hsp INNER JOIN ACCOUNT guar ON hsp.GUARANTOR _ID = guar.ACCOUNT_ID WHERE hsp.TOT_ACC_BAL < > 0 AND hsp.ACC_BILLSTS_HA_C < > 3 --Not DNB GROUP BY hsp.GUARANTOR_ID
Which HAR balances are being excluded?
A) Negative B) Zero C) Positive D) Null
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