title: SQL where clause for a named table
body: <p>How do i do a where clause to check the age show below when i don't have an age field to check it against? I'm using oracle DB.</p>
  
  <pre><code>select LNAME || ', ' || FNAME as "Name", 
         TO_CHAR(sysdate,'YYYY') - TO_CHAR(DOB,'YYYY') as AGE 
    from STAFF
   where AGE = (select min(TO_CHAR(sysdate,'YYYY') - TO_CHAR(DOB,'YYYY')) 
                  from STAFF);
  </code></pre>