title: Operators AND and OR in PL/SQL
body: <p>I have the following query and I receive output with movies of genres different from <code>Action</code>.</p>
  <pre><code>SELECT original_title, genres 
  FROM movies
  WHERE cast LIKE('%Daniel Craig%') 
     OR cast LIKE('%Christoph Waltz%') 
    AND genres LIKE('%Action%');
  </code></pre>
  <p>I want to see only genres that include Action.
  This is what I see now:</p>
  <pre><code>Spectre                          Action|Adventure|Crime
  Inglourious Basterds             Drama|Action|Thriller|War
  Lara Croft: Tomb Raider          Adventure|Fantasy|Action|Thriller
  Quantum of Solace                Adventure|Action|Thriller|Crime
  Defiance                         Action|Drama|History|War
  Flashbacks of a Fool             Drama
  The Girl with the Dragon Tattoo  Thriller|Crime|Mystery|Drama
  Cowboys &amp; Aliens                 Action|Science Fiction|Thriller|Western
  The Green Hornet                 Action|Crime|Comedy
  Dream House                      Drama|Thriller|Mystery
  One Life                         Family|Documentary
  Skyfall                          Action|Adventure|Thriller
  </code></pre>
  <p>Kind regards,
  Anna</p>