C:\Documents and Settings\Jerry\Local Settings\Temp\Temporary Directory 8 for SASCert_BaseProgramming_Memo.zip\M04 - Creating List Reports - 54 of 55.mht
quesiton 9: I think both answer a and c are correct.
Do you guys have second thought?
Thanks a lot,
jerrywu
The question is:
9. Choose the statement below that selects rows in which
the amount is less than or equal to $5000
the account is 101-1092 or the rate equals 0.095.
a. where amount <= 5000 and account='101-1092' or rate = 0.095;
b. where (amount le 5000 and account='101-1092') or rate = 0.095;
c. where amount <= 5000 and (account='101-1092' or rate eq 0.095);
d. where amount <= 5000 or account='101-1092' and rate = 0.095;
since for a, if rate=0.095; or both the other two conditions satisfied, it will be selected. But for c, you must satisfied amount<=500 and rate=0.095 both or satisfied amount<=500 and account='101-1092'.
楼主
