title: SQL Access Query to Display names of Youngest Students
body: <p>Write a query:
  <strong>Display the first and last names of the youngest students.</strong></p>
  
  <p>for the following table:<br>
  <code>STUDENT
  (School_ID char(3), St_LastName char(15), St_FirstName char(15), St_DOB char(15), St_SS# char(15), St_Address char(15),St_City char(15), St_State char(2),st_Zip char(5), st_phone char(15));</code>
  Its working but not executing values</p>
  
  <p>SELECT STUDENT.St_FirstName,STUDENT.St_DOB
  FROM STUDENT,
  (
   SELECT  MAX(STUDENT.St_DOB) AS maximum
     FROM FACULTY
  )AS YOUNG
  WHERE ((STUDENT.St_DOB) &lt;(YOUNG.maximum));</p>
  
  <p>Your answer should be specific in Microsoft Access</p>