Extra Credit (2 points) I understand that immediately after completion of each part of the exam – I must submit the pictures of my: Cheat Sheet (even if blank) Scratch paper (even if blank) I understand the failure to do so will result in loss of extra credit points; and also potentially a zero on the exam.

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