Refer to Schema B. What is the result of the following? WITH LoanCount AS (   SELECT L.memID ,COUNT(*) AS [Num]   FROM tblLOAN L   GROUP BY L.memID ) SELECT M.lastName ,LC.[Num] FROM tblMEMBER M JOIN LoanCount LC ON M.memID = LC.memID WHERE LC.[Num] >= 2;

Refer to Schema B. What is the result of: SELECT COUNT(*) – COUNT(DISTINCT L.bookID) FROM tblLOAN L WHERE L.durationDays IS NULL;

Refer to Schema B. If a LEFT JOIN is performed from tblMEMBER to tblLOAN, which member’s lastName will show NULL for the loanID column?

Ingrowing nail

Impetigo, unspecified

Acute bronchitis

Which of the following is medical insurance for a spouse and unmarried dependent children of a veteran with permanent total disability resulting from a service-related injury?

Acute pharyngitis

Otalgia, bilateral

When you encounter the word see in the Alphabetic Index, you know that ____.