title: SQL check if group containes certain values of given column (ORACLE)
body: <p>I have table audit_log with these records:</p>
  
  <pre><code>log_id | request_id | status_id
   1     |  2         |  5
   2     |  2         |  10
   3     |  2         |  20
   4     |  3         |  10
   5     |  3         |  20
  </code></pre>
  
  <p>I would like to know if there exists request_ids having status_id 5 and 10 at the same time. So this query should return request_id = 2 as its column status_id has values 5 and 10 (request_id 3 is omitted because status_id column has only value of 10 without 5).<br>
  How could I do this with SQL?<br>
  I think I should use group by request_id, but I don't know how to check if group has status_id with values 5 and 10?  </p>
  
  <p>Thanks,<br>
  mismas </p>