Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Why same records have been used twice?

 

CU_BAR_SF_00011:

Expression: '' this empty quotation is just created or where it has been used in query?

 

Financial Aid:

ANTICIPATED_AID (define):

 

CU_BAR_SF_00002:

In subquery :

C.NET_AWARD_AMT - Net Award Amount  greater than  0  (Why this > 0)?

 

CU_BAR_FA_00003:

HAVING criteria, GROUP BY (how to do this?)

Panel

AND B.STRM = A.ACCOUNT_TERM

     AND A.ACCOUNT_BALANCE > 0 )

  GROUP BY  B.EMPLID,  A.ACCOUNT_BALANCE

  HAVING  A.ACCOUNT_BALANCE - sum ( B.NET_AWARD_AMT) <= 0

  ORDER BY 1

 

A.ACCOUNT_BALANCE - sum (B.NET_AWARD_AMT)  not greater than  0  (Why?)