title: Newbie question on grails "createCriteria"
body: <p>I am new to Grails criteria builder, can someone please explain what does the following mean?</p>
  
  <pre><code>def c = Account.createCriteria()
           def results = c {
  
               like("holderFirstName", "Fred%")
               and {
                   between("balance", 500, 1000)
                   eq("branch", "London")
               }
               maxResults(10)
               order("holderLastName", "desc")
           }
  </code></pre>
  
  <p>Does it mean</p>
  
  <ul>
  <li><code>Select * from account where
  holderFirstName like 'fred%' and
  (balance between 500 and 1000 **and**
  branch='london</code>')</li>
  <li><code>Select * from account where
  holderFirstName like 'fred%' and
  (balance between 500 and 1000 **or**
  branch='london</code>')</li>
  </ul>
  
  <p>If i want to use "or" and "and" together how do I do that?</p>