title: SQL Plus SYSDATE Usage?
body: <p>i have asked a previous question about the same schema however im writing out how to solve this problem and i remember hearing something about <code>SYSDATE</code> but i am kinda unsure about what it is and how to use it properly... heres the schema, the problem and my attempt.</p>
  
  <p>Problem:  A view named <code>ProblematicMachine</code> that lists all information about the machines,
  for which more than 5 tickets where opened during the previous month (i.e., if
  we run the view in Oct, then it lists tickets for which more than 5 tickets where
  submitted in Sep, and if we run it in Nov, it list tickets for which more than 5
  tickets where submitted in Oct, and so on)</p>
  
  <p>My solution without the <code>SYSDATE</code>: </p>
  
  <pre><code>CREATE OR REPLACE VIEW ProblematicMachine AS 
  SELECT machine_name, IP, network_port, MACADDR, location_id 
  FROM Inventory, Tickets
  WHERE    *this is where i was gonna use the condition of the 
   SYSDATE i guess SYSDATE - 30 (for days). 
  </code></pre>
  
  <h2>SCHEMAS</h2>
  
  <pre><code>TECH PERSONNEL (pplSoft, fname, lname, pittID, expertise, office phone) 
  where fname is first name, and lname is last name.
  
  USERS (pplSoft, fname, lname, pittID, office phone)
  
  CATEGORIES (category id, category, description) where this table lists 
  all possible categories of submitted tickets.
  
  INVENTORY(machine name, IP, network port, MACADDR, location id)
  
  LOCATIONS(location id, location, building, notes)
  
  TICKETS (ticket number, owner pplSoft, date submitted, date closed, 
  days worked on, category id, machine name, location, description)
  
  ASSIGNMENT (ticket number, tech pplSoft, date assigned, status) 
  where status held is an enumeration, could be: assigned, 
  in progress, delegated, closed successful, or closed unsuccessful.
  </code></pre>