#3 To aid in finding a patient's latest lab result, you build the following common table expression: maxResultDate as SELECT PAT_ID, PROC_ID FROM results GROUP BY PAT_ID, PROC_ID) The column maxResultDate.PAT_ID represents one patient. The column maxResultDate.PROC_ID represents a procedure. "results" is another common table expression that contains potentially many rows of results for each patient-procedure combination. The column results. RESULT_DATE stores the date of each result. Which of the following will return the date of just the latest lab? SELECT ONE OF THE FOLLOWING (3 PTS) A. Add", RESULT_DATE" to the GROUP BY clause and the SELECT clause B. Add", RESULT_DATE" to the GROUP BY clause and an ORDER BY cause C. Add", MAX( RESULT_DATE)" to the SELECT clause D. Add", MIN( RESULT_DATE ) " to the SELECT clause